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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th May 2009, 23: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?

Thanks.

Last edited by corbinsiddall; 8th May 2009 at 02:36. Reason: Updated with more information.
Reply With Quote
Sponsored Links
  #2  
Old 8th May 2009, 09:50
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,466
Thanks: 813
Thanked 5,253 Times in 4,119 Posts
 
Default

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

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


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


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