Skip to end of metadata
Go to start of metadata


We have a large number of databases:
more than 250,000 tables (660 databases, 60 Gb).

Restoring a single database was a good time to restoring.
When restoring all databases at once, the process takes too much time: 8 hours restoring and it still didn't finish.


When databases are restored individually, the process naturally takes long time. The reason is that each row must be selected and inserted.


It is recommended to use the Files Restore function to restore large amount of databases at once. See Restoring MySQL Instance Best Practices.

Related Articles

Page: MySQL 5.5.10 - Unable to Find any Databases During Replication (Knowledge Base) Labels: mysql, database, backup
Page: Restoring Large Number of MySQL Databases (Knowledge Base) Labels: mysql
Page: Error restoring MySQL database - MySQLD executable not found! (Knowledge Base) Labels: mysql, database, restore
mysql mysql Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.