#1  
Old 3rd December 2010, 09:57
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Default Move ispconfig to new server?

Hi,
I got som realy big problem, the ext3 filsystem is verry unstable and can die anytime, i hade to restore a snapshot 2 times.

Im installing a new server debian lenny perfect setup and latest ispconfig 2.2.37. is there a way to just move/backup and restore to the new server?

i do backup at /var/www/webXX to another location and even all DB to every customer to new location.

Under tools there is a backup tools but how to restore?

Ore can i just restore all DB including ispconfig db and restore all web to the same place from the first server to the new and its going to work?

plz help
rgds
//Marcus
Reply With Quote
Sponsored Links
  #2  
Old 3rd December 2010, 11:56
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,717
Thanks: 840
Thanked 5,593 Times in 4,404 Posts
Default

Please see this thread for details:

http://www.howtoforge.com/forums/showthread.php?t=2717
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
trexen (3rd December 2010)
  #3  
Old 3rd December 2010, 19:11
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Default problem whit mysql

Hi,
got som problem after o installed all DB from backups.
following errors inte syslog:


Dec 3 18:06:40 ISP01-NEW mysqld_safe[3206]: started
Dec 3 18:06:40 ISP01-NEW mysqld[3210]: 101203 18:06:40 InnoDB: Operating system error number 13 in a file
operation.
Dec 3 18:06:40 ISP01-NEW mysqld[3210]: InnoDB: The error means mysqld does not have the access rights to
Dec 3 18:06:40 ISP01-NEW mysqld[3210]: InnoDB: the directory.
Dec 3 18:06:40 ISP01-NEW mysqld[3210]: InnoDB: File name ./ibdata1
Dec 3 18:06:40 ISP01-NEW mysqld[3210]: InnoDB: File operation call: 'open'.
Dec 3 18:06:40 ISP01-NEW mysqld[3210]: InnoDB: Cannot continue operation.
Dec 3 18:06:40 ISP01-NEW mysqld_safe[3216]: ended
Dec 3 18:06:54 ISP01-NEW /etc/init.d/mysql[3355]: 0 processes alive and '/usr/bin/mysqladmin --defaults-fil
e=/etc/mysql/debian.cnf ping' resulted in
Dec 3 18:06:54 ISP01-NEW /etc/init.d/mysql[3355]: #007/usr/bin/mysqladmin: connect to server at 'localhost'
failed
Dec 3 18:06:54 ISP01-NEW /etc/init.d/mysql[3355]: error: 'Can't connect to local MySQL server through socke
t '/var/run/mysqld/mysqld.sock' (2)'
Dec 3 18:06:54 ISP01-NEW /etc/init.d/mysql[3355]: Check that mysqld is running and that the socket: '/var/r
un/mysqld/mysqld.sock' exists!
Dec 3 18:06:54 ISP01-NEW /etc/init.d/mysql[3355]:



anything i forgot to do?
Thanx
//Marcus
Reply With Quote
  #4  
Old 4th December 2010, 12:59
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

How did you restore the MySQL database? From an SQL dump, or did you copy the database directory? If the latter, please make sure that you preserved the permissions and ownerships of that directory.
__________________
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
  #5  
Old 4th December 2010, 13:21
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Default

im doing an new installation of Debian 5.0.7 and take lots of snapshots this time =)
i try both methods, i got a verry god autobackupmysql.sh script that backup all db every night, so i restore db from thoes. and i also tryed to copy whit tar -pczf and restore it. but i dont know if i have to merge the 2 db togheter to have the right information.

ore can i just import from old mysql to the new mysql db whitout having a problem, this time i named everything exactly the same as the old one, beside IP address and gateway.

last time ispconfig setup ask me about use db_ispconfig but the old system i dbispconfig, but i create a new db to the same name and then syncronice the 2 DB in phpmyadmin and it worked fine.

btw, the old systen is Debian etch 4 and the new is Debian lenny 5.0.7

rgds
//Marcus

PS:
im going to move to ISP v3 l8r but need to get this to work asap, the old server can go down any time.
maybe i mail you and ask for paid support?
Reply With Quote
  #6  
Old 4th December 2010, 20:03
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Smile

i think i g it right this time,

but is it realy nessisary to restore mysql database from the old one?
i don´t what it to fail again =)

ore can i do something so it doesent fail?


regards
//Marcus
Reply With Quote
  #7  
Old 5th December 2010, 14:47
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
Default

I think i got the most part to work, but =)

when try to access my www page i get this error inte the web browser.

"Error establishing a database connection"


is there something to do that i dont restore the mysql DB from old to the new server?
Just try that and still the same error..

Is this has something to do whit that i diden´t restore the mysql DB?


any sugestion?

rgds
//Marcus

Last edited by trexen; 5th December 2010 at 15:09.
Reply With Quote
  #8  
Old 5th December 2010, 15:41
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,717
Thanks: 840
Thanked 5,593 Times in 4,404 Posts
Default

If you want to migrate a mysql database from one server to another, then you can not do this by simply copying the complete /var/lib/mysql directory and it will also not work to use mysqldump and dump all databases. The reason for that is that you would overwrite the "mysql" database in that case on the new server which will cause mysql to fail, as the system accounts in mysql like debian-sysmaint get overwritten. The steps that I use to migrate a mysql setup are:

1) Dump all databases that you want to migrate with the mysqldump command and import them again on the new server by piping the .sql file to the "mysql" command. You can do this for all databases except of the "mysql" database.

2) Now migrate the permission records for the mysql users. The easiest way is to expert all records for the client database users with phpmyadmin on the old server from the tables mysql.user and mysql.db and reimport them on the new database server. Make sure that you expoert only the users for the client databases and not the debian sysmaint user or the mysql root user.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #9  
Old 5th December 2010, 18:45
trexen trexen is offline
Senior Member
 
Join Date: Jun 2008
Location: Stockholm
Posts: 169
Thanks: 15
Thanked 3 Times in 2 Posts
 
Default

i just send you a prv messages.

//Marcus
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
PHP warnings after upgrade to ISP config 3.03 stevegjacobs Installation/Configuration 5 30th October 2010 15:31
problem with upgrade to 2.2.34 brianetilley Installation/Configuration 14 11th November 2009 18:22
FTP cannot open remote folder!?! andysm849 Server Operation 23 17th October 2008 00:34
subdomain and mail relay configuration aranthorn Installation/Configuration 24 3rd September 2007 23:53
Problems with Postfix Mysql Courier PatrickAdrichem Installation/Configuration 3 13th April 2007 16:44


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


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