Restoring a large dataset in MySQL
Working with large datasets in MySQL, I have been experimenting with different methods of restoring a large database backup. If the db backup file has already been produced, you can go to a MySQL command shell and use these commands to restore the database:
mysql> SET FOREIGN_KEY_CHECKS = 0;
mysql> SOURCE dump_file_name
mysql> SET FOREIGN_KEY_CHECKS = 1;
mysql> COMMIT;
This tip and more about backup and restore of MySQL can be found at the SpikeSource blog.
There are no comments for this entry.
[Add Comment]