HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (
-   Installation/Configuration (
-   -   Restore broken ispconfig settingd (

smittie2000 14th December 2012 14:52

Restore broken ispconfig settingd

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.


till 14th December 2012 14: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 15:11


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

till 14th December 2012 15: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 15:29


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

Thanks for support

All times are GMT +2. The time now is 03:40.

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