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)
-   -   Upgrade problem after having added tables to dbispconfig database (http://www.howtoforge.com/forums/showthread.php?t=40327)

DFen 22nd October 2009 17:35

Upgrade problem after having added tables to dbispconfig database
 
Just a warning to other "Tweakers" like me:o

Upgrading (upgrade.php) after having added tables to dbispconfig database upgrade completes but the database tables are not fully loaded.

For reasons not relevant to this post, I had added a table to the dbispconfig database.

When running the update.php script it completed, but the database was not fully loaded. My "new" table was missing and this breaks mysql and hence the restore is incomplete.

I found update had created a backup in my home directory:), So I removed the new table data from the backup file, emptied all the tables in the database and reloaded from the backup.

All now appears ok.

Note: In future I will create a separate database to hold my kludges!

till 22nd October 2009 17:47

It is not supported to add any tables or modify tables in the ispconfig database. If you do that, you will loose your data on upgrades as your database content is not compatible to the ispconfig database scheme.


All times are GMT +2. The time now is 08:55.

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