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 14th December 2012, 13:52
smittie2000 smittie2000 is offline
Junior Member
 
Join Date: Dec 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Restore broken ispconfig settingd

HI

I`m trying to reconfigure ispconfig 3 from a backup. After running "mysql -u root -p dbispconfig < ispconfig_db_backup.sql" i get this error "ERROR 1146 (42S02) at line 22: Table 'dbispconfig.aps_instances' doesn't exist". I have tried seeding tables and then empty info and the run backup still same error. Any help will be appreciated.

Thanks
Smittie
Reply With Quote
Sponsored Links
  #2  
Old 14th December 2012, 13:54
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,771
Thanks: 821
Thanked 5,331 Times in 4,183 Posts
Default

Seems as if you try to restore a backup from ISPConfig 3.0.5 into older version or in orher words, you are currently doing a downgrade which will not work. For the restore, the same version or a newer version of ISPConfig has to be installed on the server.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 14th December 2012, 14:11
smittie2000 smittie2000 is offline
Junior Member
 
Join Date: Dec 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

Thanks for quick reply i updated ispconfig to 3.0.5 and when i run backup now i get "ERROR 1062 (23000) at line 51: Duplicate entry '1' for key 'PRIMARY'."

Thanks for help
Smittie
Reply With Quote
  #4  
Old 14th December 2012, 14:28
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 35,771
Thanks: 821
Thanked 5,331 Times in 4,183 Posts
Default

1) Create a backup of the current database
2) Empty all tables in the database (just empty them and do not delete them) before you restore the backup. You can do this e.g. from within phpmyadmin.
3) Restore the sql backup file.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 14th December 2012, 14:29
smittie2000 smittie2000 is offline
Junior Member
 
Join Date: Dec 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Hi

After seeding tables and just emptying tables i was able to restore backup.

Thanks for support
Smittie
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
reinstall postfix after securing-short question fxs Installation/Configuration 12 30th January 2012 10:10
All files gone after changing quota to 0 spynode General 17 19th January 2012 14:41
PHP warnings after upgrade to ISP config 3.03 stevegjacobs Installation/Configuration 5 30th October 2010 14:31
ISPconfig 3: can't send or receive messages zogthegreat Installation/Configuration 6 22nd May 2010 14:45
ISPConfig 3.0.0.8 RC1 released till General 92 22nd February 2010 09:52


All times are GMT +2. The time now is 01:57.


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