On Wed, Jun 29, 2005 at 10:53:16PM -0400, Wayne Topa wrote: > mysqldump -A > backup-file.sql (on main server)
I would add the '--opt' option to mysqldump. From the man page: --opt : Same as --add-drop-table --add-locks --all --extended-insert --quick --lock-tables The main point here is that this adds the locks so the databases will not be corrupted when some update is made halfway through the dump. But I see that with mysql 4.1 this option is used by default. There is also the mysqlhotcopy program that can be of help. More info in the man pages and in the mysql docs. If hou have got the 4.1 docs then fire up a browser and go to paragraphs 8.8 and 8.9: file:///usr/share/doc/mysql-doc-4.1/manual_Client-Side_Scripts.html#mysqldump and file:///usr/share/doc/mysql-doc-4.1/manual_Client-Side_Scripts.html#mysqlhotcopy HTH, -- Maurits van Rees | http://maurits.vanrees.org/ [Dutch/Nederlands] Public GnuPG key: http://maurits.vanrees.org/var/gpgkey.asc "It can seem like you're doing just fine, but the creep's creeping into your mind." - Neal Morse
signature.asc
Description: Digital signature
