Backup of Huge Tables

[Philippe Mingo]

Hi!

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.