HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=27)
-   -   Restore broken ispconfig settingd (http://www.howtoforge.com/forums/showthread.php?t=59957)

smittie2000 14th December 2012 13:52

Restore broken ispconfig settingd
 
HI

I`m trying to reconfigure ispconfig 3 from a backup. After running "mysql -u root -p dbispconfig < ispconfig_db_backup.sql" i get this error "ERROR 1146 (42S02) at line 22: Table 'dbispconfig.aps_instances' doesn't exist". I have tried seeding tables and then empty info and the run backup still same error. Any help will be appreciated.

Thanks
Smittie

till 14th December 2012 13:54

Seems as if you try to restore a backup from ISPConfig 3.0.5 into older version or in orher words, you are currently doing a downgrade which will not work. For the restore, the same version or a newer version of ISPConfig has to be installed on the server.

smittie2000 14th December 2012 14:11

Hi

Thanks for quick reply i updated ispconfig to 3.0.5 and when i run backup now i get "ERROR 1062 (23000) at line 51: Duplicate entry '1' for key 'PRIMARY'."

Thanks for help
Smittie

till 14th December 2012 14:28

1) Create a backup of the current database
2) Empty all tables in the database (just empty them and do not delete them) before you restore the backup. You can do this e.g. from within phpmyadmin.
3) Restore the sql backup file.

smittie2000 14th December 2012 14:29

Hi

After seeding tables and just emptying tables i was able to restore backup.

Thanks for support
Smittie


All times are GMT +2. The time now is 12:26.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.