Looking for reassurance - MySQL Back-up
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
> 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