Re: MySQL innoDBD Backup

[Yally Lee]

Hi Nick,

thanks for your explaination, that's clear enough...
the conclusion is using mysqldump is the best way (am i correct?)
and then load the information back to other computer.
is there a problem using mysqldump with a huge data? (300.000 records, 60MB), i've read about mysqldump, it say mysqldump are pretty slow dealing with huge data, is that right? is there another best solution for backing up innoDB's files?

just an addition question, if im using mySqldump will my existing file being deleted? just sqldump just create a backup from the existing databases? how about the index file after i load back from the file that i create with mysqldump. will mysql backup this index file along with the tables?

many thanks


forever-