MySQL Forums
Forum List  »  Backup

Re: MySQL innoDBD Backup
Posted by: Yally Lee
Date: August 06, 2004 01:46AM

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


Options: ReplyQuote

Written By
August 01, 2004 07:44PM
August 02, 2004 03:57PM
August 04, 2004 08:36PM
August 05, 2004 02:51AM
Re: MySQL innoDBD Backup
August 06, 2004 01:46AM
August 06, 2004 04:13AM
August 09, 2004 03:50AM

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.