Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 3rd March 2007, 12:42
okhayat okhayat is offline
Junior Member
 
Join Date: May 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Database not migrated after upgrade (2.2.9->2.2.10)

After successfully upgrading my installation, I couldn't login to my control panel. I check the mysql server and I noticed that the db_ispconfig database is empty.
When inspecting the logs, I found the following:
Code:
Thu Mar 1 01:04:03 IRST 2007 - [ISPConfig] - /root/install_ispconfig/install.php, Line 795: WARNING: could not read in db_ispconfig.sql
Thu Mar 1 01:04:04 IRST 2007 - [ISPConfig] - /root/install_ispconfig/install.php, Line 802: imported existing_db.sql
I tried to restore the database manually from the mysql dump and I got an error:
Code:
cpanel:~/install_ispconfig# mysql -p db_ispconfig < db_ispconfig.sql
Enter password:
cpanel:~/install_ispconfig# mysql -p db_ispconfig < /tmp/existing_db_02_27_2007__17_20_04.sql
Enter password:
ERROR 1062 at line 164: Duplicate entry '3' for key 1
Part of the line that has the error is:
Code:
INSERT INTO `doctype` (`doctype_id`, `userid`, `groupid`, `doctype_modul`, `doctype_name`, `doctype_title`, `doctype_def`, `doctype_tree`) VALUES (3,1,1,'sys','news','News','O:3:\"doc\":28:{s:6:\"userid\";s:1:\"1\";s:7:\"groupid\";s:1:\"1\";s:14:\"group_required\";s:1:\"0\";s:5:\"modul\";s:3:\"sys\"
What's wrong?
Reply With Quote
Sponsored Links
  #2  
Old 3rd March 2007, 13:00
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,202
Thanks: 829
Thanked 5,420 Times in 4,262 Posts
Default

If you want to import the database dump, you must empty (but dont delete!) the tables in db_ispconfig before the import.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 3rd March 2007, 13:29
okhayat okhayat is offline
Junior Member
 
Join Date: May 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is there any way to empty all table at once?

Also, is this normal? I mean, shouldn't it import the data again once the software is upgraded?

Thanks,
Reply With Quote
  #4  
Old 3rd March 2007, 13:43
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,202
Thanks: 829
Thanked 5,420 Times in 4,262 Posts
 
Default

Quote:
Originally Posted by okhayat
Is there any way to empty all table at once?
If you have phpmyadmin installed, select all tables and then chose empty.

Quote:
Also, is this normal? I mean, shouldn't it import the data again once the software is upgraded?
That's not normal. I dont know why it has not imported your data. I'am doing ISPConfig installations and updates almost every day but it did not happen to me yet.
__________________
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
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
problem after upgrade from 2.2.8 to 2.2.9 smartcall Installation/Configuration 15 23rd January 2007 09:48
Failed upgrade 2.2.8 to 2.2.9 bwrob Installation/Configuration 2 16th December 2006 18:29
Upgrade question for "Virtual Users And Domains With Postfix, Courier And MySQL" emresumengen HOWTO-Related Questions 3 1st December 2006 15:33
Recreating ISPConfig database retran Installation/Configuration 2 15th April 2006 23:22


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


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