Looking for reassurance - MySQL Back-up

Gary Thornock gthornock at yahoo.com
Sun Mar 12 10:12:11 MST 2006


--- Gabriel Gunderson <gabe at gundy.org> wrote:
> Anyway, I need to backup a MySQL server before I commandeer the
> hardware it was running on.  I really would like to give the
> guys that were running it the most complete dump of data that I
> can.
>
> Tell me what you think...
>
> I added "--skip-grant-tables" to the server start-up so there
> would be no permission issues.  I then issued "mysqldump -A -a
> > full-dump.sql".  The docs seem to suggest that this will dump
> everything but I just want to be sure.  You can't put a price
> on the word of the experienced.

That's almost what I would have done.  The only difference is
that I would probably have piped it through bzip2 before saving :)




More information about the PLUG mailing list