Most of the time backups using mysqldump will include the following line:
This is OK when you're trying to either (re)build a slave or restore a production database. But what about restoring it to a test server in a different schema?
The actual trick
Using vi (or similar) editors to edit the line will most likely result in the editor trying to load the whole backup file into memory, which might cause paging or even crash the server if the backup is big [Read more...]