I realize this is a very elementary question and explained somewhat in the mysql manual.
The manual describes three different methods for backing up databases Copying the files themselves using mysqldump to dump all the tables into a single file using mysqlhotcopy The most straightforward way from an admin's point of view is just to copy the directories containing the tables. I couldn't get mysqlhotcopy to work on first try, but mysqldump did exactly as advertised. Are there any reasons to avoid the first solution (which is obviously the easiest)? I understand you'd probably need to turn mysqld off while you are running this (which is no problem for me). . How would you test if copied files could produce a viable backup? Is it as easy as changing the name of the db and then trying to access the tables? Robert Nagle --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
