Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

Unable to restore a mysql database from dump produced by mysqldump

novice.programnovice.program EntrantCurrent User Role Beginner
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

Comments

  • xaprbxaprb Mentor Inactive User Role Beginner
    Is it done yet?

    The short answer is, don't use mysqldump for really big tables.
  • kostagr33kkostagr33k Entrant Current User Role Beginner
    Any explanation as to why not to use mysqldump on large tables? Any good alternatives for both innodb and myisam tables?


    Kosta
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.