MySQL Forums
Forum List  »  Backup

Backup of Huge Tables
Posted by: Philippe Mingo
Date: September 19, 2005 09:27AM


I've got a big innodb table (1,2Gb) full of photos. I've tryed to backup it using mysqldump but the problem is (apart of being very slow) that the resulting sql is too big to handle it in an efficent way. I've tryed to restore it using mysql administrator on a windows machine, but it doesn't work. It starts analyzing and after a while stops doing nothing at all.

Is there a way to tell mysqldump to hash the resulting sql file?
Is there a better way to backup/restore innodb tables?

This table was in MyISAM format, and it worked great with backup table. But as the table kept growing I decided to convert to InnoDB to avoid corruptions problems. Is this a good idea? Or should I use MyISAM again?

Thanks al lot.

Options: ReplyQuote

Written By
Backup of Huge Tables
September 19, 2005 09:27AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.