MySQL Forums
Forum List  »  Data Recovery

Re: Mysql Database Recovery
Posted by: Mark Leith
Date: December 19, 2007 04:40AM

For very large databases I would always recommend a file system level backup (LVM, cold backup etc.). The recovery times will always be much faster than having to replay a bunch of INSERT statements or LOAD DATA commands.

Of course, LOAD DATA will be faster than a dump with INSERT statements as well, so look in to the --tab option if you continue to use mysqldump.

Options: ReplyQuote

Written By
June 27, 2007 12:40PM
December 17, 2007 11:30AM
Re: Mysql Database Recovery
December 19, 2007 04:40AM

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.