|
Key
This line was removed.
This word was removed. This word was added.
This line was added.
|
Changes (1)
View Page History
...
{page-title}{excerpt:hidden=false}Everyone Loves Taking a Dump{excerpt} h3. How Does mysqldump Work?
A big challenge with mysqldump is that performing a backup takes longer and longer as the data set grows. It also holds table locks and transactions during the entire backup operation which can interrupt users of your database while the backup is taking place. The best use of MySQL dump is to provide a weekly sanity check on database integrity. One advantage of [SQL dumps|TP:SQL Database Dump] is that they read all of the data in the database and can provide an early warning of problems with your MySQL data store or raw MyISAM files.
\\
\\
...