sunil sharma said:
Dear Friends
I am new in this list I am using mysql on linux
My problem is about the backup of mysql database
We are having 50 Databases and each database is of minimum of 300 MB in size and maximum of 2 G.B size
I am planning to take incremental backup of the database For that i am planning to use mysqldump,But i m bit doughtful about the mysqldump because the size of the database is very huge I tried but it's taking a lot of time
funny you asked that my question is similar so I'll group it with this one, hope you don't mind.
Hello all,
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 :)
thnx,
Hi,
You should not use mysqlimport to restore a backup made with mysqldump; use mysql instead. Check: http://www.mysql.com/doc/en/mysqldump.html
I am quite surprised that you could restore anything with mysqlimport :(
Regards, Joseph Bueno
--------------------------------------------------------------------- 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