Help please! Update script erased my databse.

[nikoladd]

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.

[nikoladd]

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.

[till]

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.

[nikoladd]

Originally Posted by till

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.

Originally Posted by till

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?

[till]

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?

[nikoladd]

Originally Posted by till

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...

Originally Posted by till

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.

[till]

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.