I have been using mysqldump -a to backup my clients sites. I have discovered a problem with this aproach. I decided to try and restore it with mysqlimport on my local hd and it'll restore it up to a certian point then stop. What I'm looking for is any other recomendations to backup and restore 71 databases. Any scripts for backing it all up will of course be welcom as well. second off, how do I wipe these old databases off my puter :)
You can run the dumpfile against a newly created database: mysql -u admin_user_name -p name_of_database <./dump_file.sql
If you want to update another database then you should add --add-drop-table to the mysqldump command. On the box where you need to update the database you can run the command mentioned above.
http://www.mysql.com/doc/en/Backup.html
B.
--------------------------------------------------------------------- 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