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.
7 messages in com.mysql.lists.mysqlRe: Mysql And Backup
