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
  #21  
Old 7th January 2013, 14:18
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

1) If both servers are online, then you can copy them with scp. Example:

scp www.tar.gz root@newserver.tld/tmp/

Quote:
(Why backup /etc? If you restore on a new server you will get problems?)
You should not restore it on the new server. You just backup it in case that you need any of the config details and to have the /etc/passwd, shadow, group and gshadow files at hand for step 5).

2) Backup only the client databases and dbispconfig database. The command you posted will backup all databases to one file so you get the problem that the mysql.mysql database is included but it should not be restored on the new server. You might be able to add a exclude statement if you dont o´want to backup databases one by one.

a mysql dump can be imported with:

mysql -u root -p < backup.sql
__________________
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:
stef157 (23rd March 2013)
Sponsored Links
  #22  
Old 7th January 2013, 14:28
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

Quote:
Originally Posted by skoena View Post
I have some additional questions.

1) How to get the backupped files to the new server and how to unpack them?
Please post the correct commands to use.
Been struggling with that one for my self the whole weekend, tried everything I could find about tar but always got the whole dir structure. So finally I used WinSCP to do the trick. Only hope the right are good after unpacking.

Quote:
Originally Posted by skoena View Post
(Why backup /etc?
Have the same question found different howtos some say do and others say don't

Quote:
Originally Posted by skoena View Post
2) Should I use
Code:
mysqldump --opt --user=root --password=xxxxxxxx --all-databases | gzip > mysql_backup.sql.gz
to backup db's? How to get this file to new server and how to import them back on the new server?
I am doing it right now I am importing the database with phpMyAdmin. But the client database I first have to manually recreate to import them. I luckly have only 5 clients so not that much work.

Hope it helped a bit...

Appie
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
  #23  
Old 7th January 2013, 14:51
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

Quote:
But the client database I first have to manually recreate to import them. I luckly have only 5 clients so not that much work.
If you switch steps 7 and 8 (do the resync before you import the client databases), then the database will exist.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #24  
Old 7th January 2013, 15:49
DaRKNeSS666NL DaRKNeSS666NL is offline
HowtoForge Supporter
 
Join Date: Nov 2006
Posts: 207
Thanks: 17
Thanked 5 Times in 4 Posts
Default

Quote:
Originally Posted by till View Post
Here the steps:


1) Backup the following directories on the old server: /var/www, /var/vmail and /etc, ensure that you preserve permissions e.g. with "tar pczf backupfile.tar.gz /directory/to/backup".
2) backup all mysql databases.
3) install ispconfig on the new server.
4) backup the new dbispconfig database and empty the database afterwards. Then restore the database of the old server.
5) copy all users and groups of the websites (users are web1, web2, ... , groups are client1, client2, ..., etc.) from the files /etc/passwd, /etc/shadow, /etc/group and /etc/gshadow from the old server to the new server. Copy only the lines of the users and groups, not the whole files! and make a backup of the files before you change them.
6) restore the contents of /var/vmail and /var/www on the new server.
7) restore the databases of the clients
8) Login to ispconfig, go to tools > resync, check all checkboxes and click on start and wait a few minutes to let ispconfig write missing config files.
Followed these steps over and over on my new server (local) but again and again I get the "it works" when I try to connect to a site (after chancing the host file)
And I can't login with phpMyAdMin as a user, root is working fine.
Anybody can give me a hand, I really don't know it anymore
__________________
Updating my server to Debian Squeeze, so here I go again...
Reply With Quote
  #25  
Old 17th March 2013, 13:08
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

I have dumps of all my databases but how to get them into ispconfig?

When for example I import the old dbispconfig and import it into the new server I see al db's in ispconfig but not under phpmyadmin. How to do this?
Reply With Quote
  #26  
Old 23rd March 2013, 17:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Quote:
Originally Posted by skoena View Post
I have dumps of all my databases but how to get them into ispconfig?

When for example I import the old dbispconfig and import it into the new server I see al db's in ispconfig but not under phpmyadmin. How to do this?
You need to import the SQL dumps of all the other databases as well.
__________________
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
  #27  
Old 7th April 2013, 15:28
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

But how to import them?
Of many DB's I don't have the users password, so I want to import them but passwords must be installed before?

What to do with the mysql database? On my new server I have new passwords for ex. ispconfig so I can't simply import it back?

Last edited by skoena; 7th April 2013 at 18:56.
Reply With Quote
  #28  
Old 16th April 2013, 15:57
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Any tips on how to import the DB's I I don't know the DB's passwords.

Please give me the steps and commands to use to get this done.
Reply With Quote
  #29  
Old 19th April 2013, 19:29
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
Default

Please can somebody help? ...
Reply With Quote
  #30  
Old 26th April 2013, 13:47
skoena skoena is offline
Senior Member
 
Join Date: Sep 2009
Location: Emmen, Netherlands
Posts: 421
Thanks: 77
Thanked 13 Times in 11 Posts
Send a message via MSN to skoena Send a message via Skype™ to skoena
 
Default

Falko, Till, others? Any tips how to to import the db's?
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
500 internal error after upgrade abintipl Installation/Configuration 9 18th July 2012 12:51
ISPConfig 3 Installation - Postfix queue stuck andrew971218 Installation/Configuration 21 15th July 2011 14:42
Webmail problems with only one domain? compner Installation/Configuration 14 16th February 2010 16:59
Rejecting outbound mail tristanlee85 General 11 20th May 2007 17:04
Problems with Postfix Mysql Courier PatrickAdrichem Installation/Configuration 3 13th April 2007 15:44


All times are GMT +2. The time now is 06:43.


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