Migrate to new server

[till]

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

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

(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

[DaRKNeSS666NL]

Originally Posted by skoena

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.

Originally Posted by skoena

(Why backup /etc?

Have the same question found different howtos some say do and others say don't

Originally Posted by skoena

2) Should I use

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

[till]

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.

[DaRKNeSS666NL]

Originally Posted by till

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

[skoena]

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?

[falko]

Originally Posted by skoena

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.

[skoena]

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?

[skoena]

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.

[skoena]

Please can somebody help? ...

[skoena]

Falko, Till, others? Any tips how to to import the db's?