3.5.1 How Do I Make A Temporary Copy of My Server For Testing?

3.5.1.1 Objectives
3.5.1.2 Example Execution
3.5.1.3 Discussion
3.5.1.4 Permissions Required
3.5.1.5 Tips and Tricks

When diagnosing a problem or needing to experiment with a server for developing new features or test modifications, you often need a duplicate of your running server so that you can ensure your solution works for the actual server. It would be really convenient if we had a process to make a copy of a running server for such processes.

Although it is possible and indeed popular to use replication to replicate all of your data to multiple slaves and use one of the slaves for these purposes, cases where you are working with a particular server or if replication is not in use you will need some way to duplicate not only the data but also the server and its startup parameters.