Migrate to new server

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.

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

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

 

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

 

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.

 

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?

 

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.

 

Please can somebody help? ...

 

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

 

You just need the MySQL root password for importing DBs: http://www.howtoforge.com/faq/6_4_en.html

 

But users have added their own DB passwords. How to import the DB'w into ispconfig (how to get them listed in ispconfig?) When I import them will it create the correct DB with the users PW automatically?

 

@skoena: no. users and pass are in master-DB in MySQL.
If you imported your dbispconfig-DB from old server you get them listed in ISPconfig (bot not in mysql...)

Well thats the point: NO, Resync soes not create database nor users !!! (See on german forum: http://www.howtoforge.de/forum/35592-post1.html

I will post solution here as well (if there is one...)

 

no answer? what does this resync-thing do?

 

Tried to migrate.
I have an issue. My jobqueu stays very full, do I need to update a password of the dbispconfig or someting?

Rudolf.

 

Followed these steps:

Did this to get a dump of all DB's:

Copied the sql file via scp to the new server:

Imported:

I have an issue. My jobqueu stays very full, do I need to update a password of the dbispconfig or someting?

Rudolf.

 

i looked into my ispconfig files for dbispconfig pass and set it in phpmyadmin for ispconfig user and it worked!
this pass is set by ispconfig setup, so it is different for new server!

 

Tnx beyerservice

Can you please tell exactly where to get this password and which file to update it in?

 

Another thing.
On all the sites I got the default Welcome to your website instead of the website it self.

Any tips?

 

you can find that pass on the new server for example in

Code:

/etc/postfix/mysql-virtual_domains.cf

just look for the line with password.

now you have to change the mysql password of this user (see in that file too) in mysql-server. how to do that, see for example http://blog.marceloaltmann.com/en-c...ysql-pt-trocando-a-senha-do-usuario-no-mysql/

your second problem could caused by this db problem too, because ispconfig cant access that mysql-db and did not create proper apache vhost files.
If you changed that password, you should resync your settings and wait, until your job-que is emty. Some reboot after that
is a good idea too

i hope you get it working soon :-D