GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Unable to restore a mysql database from dump produced by mysqldump

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

  • Unable to restore a mysql database from dump produced by mysqldump

    Hello All,

    I have made a dump of my database in which one table is pretty huge (about 4 million records) and has good number of indices(One full text index along with a primary key and 3 unique indices). When i try to restore this dump the restore hangs(its been running for five days now) when it tries to execute the statement which enables keys (ALTER table x ENABLE keys).

    Any suggestions on how to go about restoring this dump are more than welcome. The table in question is a myisam table.

    Thanks

  • #2
    Is it done yet?

    The short answer is, don't use mysqldump for really big tables.

    Comment


    • #3
      Any explanation as to why not to use mysqldump on large tables? Any good alternatives for both innodb and myisam tables?


      Kosta

      Comment


      • #4
        Because it takes forever to restore. Check out XtraBackup.

        Comment

        Working...
        X