•  

Announcement

Announcement Module
Collapse
No announcement yet.

what's the fastest way to restore a large mysql database?

Page Title Module
Move Remove Collapse
Conversation Detail Module
Collapse
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts

  • what's the fastest way to restore a large mysql database?

    #1
    Hi All,

    mysqldump generates a file that is about 3GB for us. Dumping that data back into mysql looks like a 10+ hour process.

    Is there a better way?

    Can one just "grab" the mysql data store and move it?

    is mysqldump the only way?
    Tags: None
  • #2
    use innodb hot backup http://www.innodb.com/doc/hot_backup/manual.html for innodb storage engine
    for myISAM you can copy data files for backup.

    Comment

    • #3
      Thanks, I will look into that. I think what we'll end up doing is use a combination of mysqldump with --ignore-table for large tables that we don't need in testing and use mysqldump with --where clause for the same large tables to limit the number of records that get loaded.

      Comment

      Working...
      X