Following up on Ronald Bradford’s Checked your MySQL recovery process recently? post, I wish to add a prequel.
To see whether you have a clear definition of your backup requirements, ask yourself these questions:
Is there a backup/restore plan?
Is there a written backup/restore plan?
How fast do you need to recover a backup? What’s the longest downtime you [...]
Following Restore one table from an ALL database dump and Restore a Single Table From mysqldump, I would like to add my own thoughts and comments on the subject.
I also wish to note performance issues with the two suggested solutions, and offer improvements.
Problem relevance
While the problem is interesting, I just want to note that it [...]
mysqldump is commonly used for making a MySQL database backup or for setting up a replication.
As in all mysql binaries, there are quite a few parameters to mysqldump. Some are just niceties but some flags are a must. Of course, choosing the parameters to use greatly depends on your requirements, database setup, network capacity etc.
Here [...]