Migration problems

[Krisxxx]

Hi
Im moving from 1 server to another using your migrate how to: http://www.isp-control.net/documentation...cp_server.

But when i on server2 is trying to import the mysql dump:
mysql < /root/mysqldump.sql

I get following error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I also cant get the ispcp frontpage to come up.

What could the problem be? Everything went fine without any error messages untill now.

Hope you can help me.

Greets
Kris

[BeNe]

First you must set a MySQL Password. Have you done this on the new Server ? And then you can connect to the MySQL Server to import the DB.

Greez BeNe

[Krisxxx]

BeNe Wrote:First you must set a MySQL Password. Have you done this on the new Server ? And then you can connect to the MySQL Server to import the DB.

Greez BeNe

Hi again
I have set a root password at the installation of ispcp of server2. Now after i have tried this command line mysql < /root/mysqldump.sql i also get an access denied error when i boot the server. Its very strange. I have looked in the mysql log, but its empty.

What could the problem be?

[Krisxxx]

When i try to start mysql i get this message:
server3:~# /etc/init.d/mysql start
Starting MySQL database server: mysqld already running.
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'

[Krisxxx]

Is it possible to migrate ispcp to server 2 without installing ispcp on server 2 first?

[BeNe]

Quote:Is it possible to migrate ispcp to server 2 without installing ispcp on server 2 first?

I´m not sure, never tested...
But you should take a look about your MySQL Server.
This must work without any Problems, then the rest will also work.

Greez BeNe

[Krisxxx]

I still get the same error: get following error:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

I have been installing debian and ispcp 5 times now and still get the same message although i have setup a root password. Have also tried to install mysql server and setting up root password before installing ispcp.

What could be the problem?

[Zothos]

mysql -u root -p < /root/mysqldump.sql
then you are prompted for the root password

typical layer8 problems...

[Krisxxx]

Zothos Wrote:mysql -u root -p < /root/mysqldump.sql
then you are prompted for the root password

typical layer8 problems...

That was the problem. Thank you very much!!!