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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 16th September 2010, 10:00
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 Posts
Default

Quote:
Are there a way to use the backup and run a manual database upgrade?
No. The upgrade is done by the ispconfig setup script during the ispconfig update. What you can try is that you use just the insert lines for the isp_isp_web table from the existing_db_09_12_2010__16_49_43.sql file and execute them with phpmyadmin in the ispconfig database.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Sponsored Links
  #12  
Old 16th September 2010, 10:18
vulfs vulfs is offline
Junior Member
 
Join Date: Dec 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Default

#1054 - Unknown column 'web_list' in 'field list'

when I use the insert. think that where the error from the upgrade must be..

But I saw no errors under the upgrade...

Could be the web_list was added in another update, and this latest just assumes that table exists. I didnt see any prerequisist when i downloaded this latest.

What sql should i use to add web_list correctly?

The start of the insert looks like this:

INSERT INTO `isp_isp_web` ( `doc_id` , `doctype_id` , `web_host` , `web_domain` , `web_speicher` , `web_traffic` , `web_cgi` , `web_php` , `web_ssi` , `web_ftp` , `web_frontpage` , `web_mysql` , `web_list` , `web_listlimit` , `web_postgresql` , `web_shell` , `web_shop` , `web_phpmyadmin` , `web_webmail` , `web_webalizer` , `web_ssl` , `status` , `ssl_request` , `ssl_cert` , `ssl_action` , `web_ip` , `server_id` , `optionen_mysql_user` , `optionen_mysql_passwort` , `web_dns` , `web_userlimit` , `web_domainlimit` , `ssl_state` , `ssl_locality` , `ssl_organization` , `ssl_organization_unit` , `ssl_country` , `web_dns_mx` , `ssl_days` , `web_httpd_include` , `web_anonftp` , `web_anonftplimit` , `optionen_frontpage_passwort` , `optionen_mysql_remote_access` , `optionen_local_mailserver` , `web_faktura` , `optionen_logsize` , `optionen_directory_index` , `web_php_safe_mode` , `web_wap` , `web_standard_cgi` , `web_individual_error_pages` , `error_401` , `error_404` , `error_403` , `error_500` , `error_400` , `error_405` , `error_503` , `web_mysql_anzahl_dbs` , `web_mailuser_login` , `web_traffic_ueberschreitung` , `web_traffic_status` , `web_mysql_quota` , `web_mysql_quota_exceeded` , `web_mysql_quota_used_fract` , `web_mailquota` , `web_cgi_mod_perl` , `web_stats` , `webalizer_stats` )

Last edited by vulfs; 16th September 2010 at 10:22.
Reply With Quote
  #13  
Old 17th September 2010, 14:46
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

What was your previous ISPConfig version? Was it a stable release or one from SVN?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #14  
Old 17th September 2010, 14:51
vulfs vulfs is offline
Junior Member
 
Join Date: Dec 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Red face

As i wrote I dunno what version.. about a year and it was a stable..

Can i downgrade and then import sql, and then upgrade one by one?

Last edited by vulfs; 17th September 2010 at 15:03.
Reply With Quote
  #15  
Old 18th September 2010, 13:11
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

You can restore your previous working installation from the backups in the /tmp directory - there's the SQL dump and two tar.gz files, one contains /root/ispconfig and the other one /home/admispconfig.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #16  
Old 26th September 2010, 15:13
vulfs vulfs is offline
Junior Member
 
Join Date: Dec 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Default

the weblist do not exsist in the new version.. then how do i get the backup sql into the database??
Reply With Quote
  #17  
Old 26th September 2010, 15:18
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 Posts
Default

You can restore .sql files with phpmyadmin or the mysql commandline application.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #18  
Old 26th September 2010, 16:36
vulfs vulfs is offline
Junior Member
 
Join Date: Dec 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
Default

I know that.. But the problem is that the current database made from the upgrade dont contain the web_list. So when I try to run the sql backup phpmyadmin comes with error..
Reply With Quote
  #19  
Old 27th September 2010, 13:28
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

You can delete the current database, create a new, empty one and then restore the database from the SQL dump.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #20  
Old 27th September 2010, 13:59
vulfs vulfs is offline
Junior Member
 
Join Date: Dec 2007
Posts: 27
Thanks: 4
Thanked 0 Times in 0 Posts
 
Default

Nothing happens.

Have attached the DB..

When I try to import with php, webmin IE or firefox.. no errors and nothing are done with the DB??

And the backup files are gone from /tmp???

Lucky i downloaded the sql.

Any idea how and or where they can be?
Attached Files
File Type: zip existing_db_.zip (41.6 KB, 94 views)

Last edited by vulfs; 27th September 2010 at 14:03.
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
Vhosts...conf not synced to changes crypted General 50 24th April 2010 00:54
The system is currently updating the configuration files. warlock General 8 21st February 2009 18:15
writeconf.php matiasCU Installation/Configuration 4 23rd December 2008 12:36
High Availability Samba cluster - DRBD + Heartbeat djalex Server Operation 58 25th May 2007 19:38
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19


All times are GMT +2. The time now is 04:51.


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