Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 22nd October 2009, 17:35
DFen DFen is offline
Junior Member
 
Join Date: Jul 2009
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Exclamation Upgrade problem after having added tables to dbispconfig database

Just a warning to other "Tweakers" like me

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!

Last edited by DFen; 22nd October 2009 at 17:37. Reason: Clarify title
Reply With Quote
Sponsored Links
  #2  
Old 22nd October 2009, 17:47
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,421
Thanks: 834
Thanked 5,500 Times in 4,329 Posts
 
Default

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.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Loads of mysql connections to dbispconfig StrikerNL General 2 5th March 2009 14:31
ISP Config hesitation when opening web pages frankb Installation/Configuration 7 15th December 2008 13:06
network issues now it says "401 The web site is blocked by administrator" Check General 3 26th February 2008 14:22
Apache2 Freezes celtic Server Operation 31 28th May 2007 17:18
php script injections Grizzly General 21 18th July 2006 08:55


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


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