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 21st November 2009, 22:58
nikoladd nikoladd is offline
Junior Member
 
Join Date: Jun 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help please! Update script erased my databse.

I updated my ispconfig today from 3.0.1.3 to 3.0.1.6.

First call to the update script asked about mysql password in the middle of a line and I did press an enter. The result is that the script failed. However when the script succeeded on the second run my ispconfig database was empty. Thus there is no data whatsoever about my configuration. That's about 40 domains,ftp users and databases.

Any ideas how I can restore parts of my configuration or the panel to a working condition?

The "auto backup" is naturally empty.

Any help would be appreciated.
Reply With Quote
Sponsored Links
  #2  
Old 22nd November 2009, 11:37
nikoladd nikoladd is offline
Junior Member
 
Join Date: Jun 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is there any mirror data that I could use stored anywhere? I've basically lost all ispconfig data except attempts_login,monitor_data,sys_ini and web_traffic tables.

Any help would be welcome...

Any way to read metadata back from the actual file folders?

How do I reset to a default ispc3 configuration? Fresh install might wipe some of my sparse data.

Last edited by nikoladd; 22nd November 2009 at 13:47.
Reply With Quote
  #3  
Old 22nd November 2009, 14:37
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

There is a backup in your root folder.

You must have edited or added any columns or tables to the ispconfig database so that your db schema did not matched he ispconfg database scheme anymore which resulted in the problem that the updater could not add the data back into the database after installing the new db scheme. You have to remove all columns or tables that you added manually in the ispconfig db to be able to install updates again.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 22nd November 2009, 16:43
nikoladd nikoladd is offline
Junior Member
 
Join Date: Jun 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
There is a backup in your root folder.
YES. That's the BROKEN auto backup I mentioned above. It contains just a few of the tables data.

Quote:
Originally Posted by till View Post
You must have edited or added any columns or tables to the ispconfig database so that your db schema did not matched he ispconfg database scheme anymore which resulted in the problem that the updater could not add the data back into the database after installing the new db scheme. You have to remove all columns or tables that you added manually in the ispconfig db to be able to install updates again.
Nope. I've never changed anything in that DB. something else went wrong and you should think of a better backup mechanism as this one failed miserable.

I had to begin with a "fresh" install as you can imagine that I can't lose any more time.

My sites now somewhat "work" from the old config in the filesystem and databases, which lessens the pressure a bit.

Now my problem is to recreate metadata in the ispc to match the one I have in my system. Any thoughts?
Reply With Quote
  #5  
Old 23rd November 2009, 15:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

Ispconfig uses the backup tool "mysqldump/ which is part of mysql for backups. this is very reliable. maybe you had not enough free space on your harddrive.

Do you have any other backups of your mysql databases which might include the ispconfig db too?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #6  
Old 23rd November 2009, 23:00
nikoladd nikoladd is offline
Junior Member
 
Join Date: Jun 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till View Post
Ispconfig uses the backup tool "mysqldump/ which is part of mysql for backups. this is very reliable. maybe you had not enough free space on your harddrive.
There is quite a lot of free space 30GB+ so that's not the case.

There was however a problem with broken index on table after the data was lost. Unfortunately the two tables with broken indexes were from the set of surviving tables. Maybe because of a lock. What an irony...

Quote:
Originally Posted by till View Post
Do you have any other backups of your mysql databases which might include the ispconfig db too?
I don't. I have backup of my data, but not of ispc database.
I obviously underestimated the impact of a "panel upgrade". With the typical panel setup that wouldn't break the whole server. I'll know better from now on, but it was costly.

By the way at the same time I did an update of a plesk server including one major version update and 3 minor version updates. No problems there with probably 25 automated updates in 3 years. Hope you'll get at that level of redundancy soon too.

I think that this is a very weak point in the ispc update process. Maybe it's a good idea to separate the process into two stages(backup and update) and actually check what was exported. Mysql dump is far from the best way to export a DB from php if you want feedback IMHO.
Reply With Quote
  #7  
Old 24th November 2009, 08:05
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
 
Default

Quote:
By the way at the same time I did an update of a plesk server including one major version update and 3 minor version updates. No problems there with probably 25 automated updates in 3 years. Hope you'll get at that level of redundancy soon too.
I did many hundred of updates on ispconfig systems mysqlf and never lost any data. Your database must have been really damaged or corrupted before the update if mysqldump was not able to extract the data anymore. mysqldump works very reliable, it is used on ispconfig setups for many years without any problems.
__________________
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
freebsd 7, samba 3, domain controller alexdimarco Suggest HOWTO 6 5th November 2010 16:54
multiple server update server.php script SrTango General 4 17th October 2009 03:23
The system is currently updating the configuration files. warlock General 8 21st February 2009 18:15
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 19:38
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19


All times are GMT +2. The time now is 02:32.


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