Restoring MySQL Instance Best Practices

If you have hundreds of databases and want to restore all of them, these Best Practices are for you.

Individual database restore is much slower then a straight raw file restore of your MySQL data directory. When databases are restored individually (see [Restoring a MySQL Database]), each row must be selected and inserted and this takes a very long time. So we recommend to shut down your MySQL instance and restore your MySQL data directory using the *file restore* feature (see [Restoring Files]). Follow the instructions below.

----
{toc:location=top|maxLevel=3|minLevel=3|type=flat|separator=pipe|style=border:1}

----
h3. Windows

1. Identify the MySQL {{data}} directory.

!mysql1.png!

2. Stop the MySQL instance. The following screen-shot shows how to do it using the Windows MySQL Administrator.

!mysql2.png!

4. Use CDP to perform a file restore of the MySQL {{data}} directory. Refer to [Restoring Files].

5. Start the MySQL instance. The following screen-shot shows how to do it using the Windows MySQL Administrator:

!mysql3.png!

1. Identify the MySQL {{data}} directory. For this purpose you can use the {{show variables}} command as shown below.

!show-var.png!

3. Move the contents of the {{data}} directory to another location as a backup.

!cp.png!

4. Use CDP to perform a file restore of the MySQL {{data}} directory. Refer to [Restoring Files].

{excerpt:hidden=true}Instructions on how to restore entire MySQL instance on Windows and Linux.{excerpt}