error when restoring phpbb3 database

Posted: 2011-10-09, 21:53 (No subject)

My idea is that the table phpbb_posts was fully recreated but afterwards it takes to long to reactivate the indexes.
Set the option "Ignore enable keys" to yes and repeat the restoring process.

Afterwards you'll have to enable the keys manually.

**uses MSD regulary** Joined: 23 Apr 2008 Posts: 11

Thanks! It worked and the restore was complete. How do one enable keys manually?

Posted: 2011-10-10, 08:05 (No subject)

Home / Databases / select a database

If MySQLDumper detects deactivated keys there will be a button "enable keys". You will run into timeouts. Simply don't get confused and repeat this until all keys are enabled.

**uses MSD regulary** Joined: 23 Apr 2008 Posts: 11

Thanks! Worked very well and was very easy to do.

Posted: 2011-10-10, 18:51 (No subject)

You are welcome. Thanks for your kind feedback.
Have fun using MySQLDumper. Wink