News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Problem with database after restore from backups

Started by messire_Leonard, February 12, 2016, 03:51:59 AM

Previous topic - Next topic

messire_Leonard

Good day!
I had to restore http and sql from backups (backups of sql was made by mysqldump).
I restored SMF by phpmyadmin (uploaded sql.gz file and restore than).
But after, I have a problem - as it seems to me, all indexes are broken coz I have a mistakes about duplicate record '0' for key 'PRIMARY'
How I can fix it if it's possible?
Thank you.

Shambles

Did you try restoring using mysqldumper, rather than via executing the sql.gz content?


messire_Leonard

No, I tried to restore by PHPMyAdmin.
So, by the way, I tried to change the options keys for mysqldump
it was: --add-drop-table --allow-keywords --skip-opt --events -q- -c -u .............
and now: --opt --flush-logs --single-transaction --routines --events --triggers --add-drop-table --extended-insert  ....
and than I tried to restore and it happends )))
Maybe I was some mistaken in keys for mysqldump options? If it's true, how I can fix it and restore my DB?

Shambles

My mistake - I misread your mysqldump as mysqldumper. Different thing (but a superior sql backup system, imho).

Advertisement: