View Single Post
  #1  
Old 22nd October 2009, 18: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 18:37. Reason: Clarify title
Reply With Quote
Sponsored Links