Symptom
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.
Cause
When databases are restored individually, the process naturally takes long time. The reason is that each row must be selected and inserted.
Resolution
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 |