Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 8th May 2009, 00:40
corbinsiddall corbinsiddall is offline
Junior Member
Join Date: May 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ispconfig_update.sh wiped all my dbispconfig databases

So I ran the update, everything seemed to work fine. Went to log into the admin page and it wouldn't take my password. I hopped over to /phpmyadmin and all the tables are empty.

My sites still work. What should I do?

Specifically since I didn't have a backup of the DB and I assume the update script didn't make one, I will need to reinput the Clients, Client Permission Templates, Sites, FTP Users. This isn't that big of a deal, but with the websites are all still working. Will re-adding them overwrite what is already live?

Plus there is no Admin user anymore so what would be a SQL statement that would get me back in the system?


Last edited by corbinsiddall; 8th May 2009 at 03:36. Reason: Updated with more information.
Reply With Quote
Sponsored Links
Old 8th May 2009, 10:50
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

The update script makes a backup of the database, it is in the /root directory.

Plus there is no Admin user anymore so what would be a SQL statement that would get me back in the system?
You can restore it from the backup.

I guess you tried to update a SVN version with a stable version which can not work of course as the SVN version contains more database tables as the stable version. SVN versions can only be updated from svn and not from a stable version!
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote


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 15:31
Restore deleted databases sojic Installation/Configuration 6 18th November 2008 13:53
phpmyadmin showing no databases nolimitek Installation/Configuration 5 15th November 2007 17:05
site - databases trueshanti Installation/Configuration 20 26th May 2006 02:28
Recovering unlinked mysql databases and users... Dave Lane Installation/Configuration 2 10th May 2006 20:45

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

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