1 |
I use mysqldump to back up a database from a development environment and |
2 |
upload it to a production environment. |
3 |
|
4 |
A couple of days ago I was surprised to see that I was getting errors as soon |
5 |
as I uploaded the backed up database to the production machine! I repeated |
6 |
the backup (more in disbelief than anything else) but the error remained. |
7 |
|
8 |
I spent a few minutes looking around and scratching my head as to what was |
9 |
amiss with it, until eventually I noticed that the recent backup was smaller |
10 |
than the previous version (it should have been bigger due to extra data that |
11 |
has accumulated in the database). I had another final go in running the same |
12 |
good ol' mysqldump command and this time it worked. The backup was a |
13 |
reasonable size and the upload restored the application in the production |
14 |
environment in a good working order. |
15 |
|
16 |
Is there a right and a wrong way of backing up mysql? Did I do something |
17 |
wrong? How should one verify that a back up is sound? (Imagine trying to |
18 |
restore from that incomplete backup!) |
19 |
-- |
20 |
Regards, |
21 |
Mick |