Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Tips/Tricks/Mods

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 22nd January 2007, 11:38
kaneda kaneda is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Question Update MySQL In debian with ISPCONFIG

Hello I have an hosting system based on a debian 3.1 with a mysql db v 4.0.24 I want to update that version to v5 (using apt repositories with testing version software, actualli installed with stable) my question is...
When I change the apt sources config to get testing versions and run apt-get upgrade, what will happend with the ISPConfig data Stored in Mysql?

Will the update maintain my data and connections will be able to stablish from ISPConfig to new DB without problems?

Thanks

P.S. ¿Will be any problem for using testing versions with ISPConfig?
Reply With Quote
Sponsored Links
  #2  
Old 23rd January 2007, 17:22
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Quote:
Originally Posted by kaneda
When I change the apt sources config to get testing versions and run apt-get upgrade, what will happend with the ISPConfig data Stored in Mysql?
The contents of the database isn't touched at all.

Quote:
Originally Posted by kaneda
Will the update maintain my data and connections will be able to stablish from ISPConfig to new DB without problems?
ISPConfig works fine with MySQL 5, so that's no problem. However, you should back up your system before doing the upgrade. And maybe it's better to use the MySQL5 version for Debian Sarge from www.dotdeb.org instead of from testing.
__________________
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
  #3  
Old 24th January 2007, 09:38
kaneda kaneda is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default System update without config loss

Thanks for the reply and great link the dotdeb, just another question if you allow me.

If I add the dotweb to apt-get sources I would be great to have not only mysql but all the services with versions more up-to-date than the "standar stable" versions that use to be older.

The question is if I make an apt-get update, the apt-get upgrade, and the system install the new versions for paquets like postfix, apache, courier...

¿Will the system de able to maintain configuration of the different programs and continue running all of them integrated with ISPConfig like before the update? Or I will have to modify again configuration files of postfix, apache, ...

Is very important to maintain up-to-date versions for security reasons but i feel a lot of fear of start again the configuration.

Anyway if I lost config, what do you think could be the most faster and easy method for dissaster recovery (Ghost is not an option, I only have console access).

THanks a lot for your help and for the software, Is a great panel.
Reply With Quote
  #4  
Old 24th January 2007, 09:45
till till is online now
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,972
Thanks: 825
Thanked 5,367 Times in 4,214 Posts
Default

You can not update all programs to newer versions by adding the dotdeb sources. First, dotdeb does not contain the latest versions for all software, it is mainly used to get the latest PHP and mysql. Also you will most likely break your configuration when you do such a update.

If you want to get newer packages from all software, either use Ubuntu server instead of Debian or update to the next debian stable release when its hopefully released in the next few weeks.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 24th January 2007, 09:53
kaneda kaneda is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Mysql Upgrade

I tryed to do a mysql upgrade -s but I does not get MySQL v 4.1, the only way to install v4.1 is to make an apt-get install mysql-server-4.1 and if I run it with -s for simulation the result that I have is that install will attemp to remove Mysql 4.0 and Install v4.1.

In that process Im not sure if data will remain when I look for it in v4.1, and even I make a full dump of mysql 4.0 databases, will this dump be compatible with the MySQL 4.1 to recover the data?

thanks again
Reply With Quote
  #6  
Old 25th January 2007, 18:38
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
 
Default

Quote:
Originally Posted by kaneda
will this dump be compatible with the MySQL 4.1 to recover the data?
Yes, at least I've never had problems with MySQL 4.0 dumps on MySQL 4.1.
__________________
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
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
HotSaNIC domino Tips/Tricks/Mods 23 6th November 2006 05:19
ISPConfig 2.3.1-dev released till General 0 8th May 2006 22:18
SP-Server Setup - Ubuntu 5.10 "Breezy Badger" - Page 6 (changes) LuisC-SM HOWTO-Related Questions 0 21st April 2006 15:16
e-mail problem!!! Debian 3.1 maroonworks Installation/Configuration 18 6th December 2005 14:42
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


All times are GMT +2. The time now is 09:52.


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