Current time: 12-11-2019, 04:42 AM Hello There, Guest! (LoginRegister)


Post Reply 
Migration problems
Author Message
Krisxxx Offline
Junior Member
*

Posts: 88
Joined: Feb 2008
Reputation: 0
Post: #1
Migration problems
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
(This post was last modified: 09-04-2008 05:13 AM by Krisxxx.)
09-04-2008 05:11 AM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #2
RE: Migration problems
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
09-04-2008 05:43 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Krisxxx Offline
Junior Member
*

Posts: 88
Joined: Feb 2008
Reputation: 0
Post: #3
RE: Migration problems
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?
09-05-2008 02:57 AM
Find all posts by this user Quote this message in a reply
Krisxxx Offline
Junior Member
*

Posts: 88
Joined: Feb 2008
Reputation: 0
Post: #4
RE: Migration problems
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)'
(This post was last modified: 09-05-2008 03:23 AM by Krisxxx.)
09-05-2008 03:23 AM
Find all posts by this user Quote this message in a reply
Krisxxx Offline
Junior Member
*

Posts: 88
Joined: Feb 2008
Reputation: 0
Post: #5
RE: Migration problems
Is it possible to migrate ispcp to server 2 without installing ispcp on server 2 first?
09-05-2008 01:38 PM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #6
RE: Migration problems
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
09-05-2008 09:22 PM
Visit this user's website Find all posts by this user Quote this message in a reply
Krisxxx Offline
Junior Member
*

Posts: 88
Joined: Feb 2008
Reputation: 0
Post: #7
RE: Migration problems
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?
(This post was last modified: 09-09-2008 08:06 PM by Krisxxx.)
09-09-2008 08:05 PM
Find all posts by this user Quote this message in a reply
Zothos Offline
Release Manager
*****
Dev Team

Posts: 1,262
Joined: Feb 2007
Reputation: 10
Post: #8
RE: Migration problems
mysql -u root -p < /root/mysqldump.sql
then you are prompted for the root password

typical layer8 problems...
09-09-2008 08:13 PM
Find all posts by this user Quote this message in a reply
Krisxxx Offline
Junior Member
*

Posts: 88
Joined: Feb 2008
Reputation: 0
Post: #9
RE: Migration problems
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!!!Smile
09-11-2008 02:24 AM
Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)