Gentoo Archives: gentoo-user

From: Mick <michaelkintzios@×××××.com>
To: gentoo-user@l.g.o
Subject: [gentoo-user] [OT] Incomplete mysql backup
Date: Thu, 19 Aug 2010 19:04:19
1 I use mysqldump to back up a database from a development environment and
2 upload it to a production environment.
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.
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.
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


File name MIME type
signature.asc application/pgp-signature


Subject Author
Re: [gentoo-user] [OT] Incomplete mysql backup kashani <kashani-list@××××××××.net>