+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Migration (/forum-35.html)
+--- Thread: Migration problems (/thread-4181.html)
Migration problems - Krisxxx - 09-04-2008 05:11 AM
Hi
Im moving from 1 server to another using your migrate how to: http://www.isp-control.net/documentation/howto/miscellaneous/migrate_from_one_to_another_ispcp_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
RE: Migration problems - BeNe - 09-04-2008 05:43 AM
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
RE: Migration problems - Krisxxx - 09-05-2008 02:57 AM
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?
RE: Migration problems - Krisxxx - 09-05-2008 03:23 AM
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)'
RE: Migration problems - Krisxxx - 09-05-2008 01:38 PM
Is it possible to migrate ispcp to server 2 without installing ispcp on server 2 first?
RE: Migration problems - BeNe - 09-05-2008 09:22 PM
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
RE: Migration problems - Krisxxx - 09-09-2008 08:05 PM
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?
RE: Migration problems - Zothos - 09-09-2008 08:13 PM
mysql -u root -p < /root/mysqldump.sql
then you are prompted for the root password
typical layer8 problems...
RE: Migration problems - Krisxxx - 09-11-2008 02:24 AM
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!!!
