HI Johan
Thank you for the advice... Problem resolved.
Regards
Machiel
-Original Message-
From: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Moving of databases from one server to another
Date: Wed, 8 Dec 2010 11:15:52 +0100
On Wed, Dec 8, 2010 at
On Wed, Dec 8, 2010 at 11:05 AM, Machiel Richards wrote:
> Hi Johan
>
> Would the server require a restart after this or not?
>
You can restart to check that the credentials in file and database match, to
avoid surprises later, but the server operation itself is not impacted by
this.
That u
Hi Johan
Would the server require a restart after this or not?
Machiel
-Original Message-
From: Johan De Meersman
To: Machiel Richards
Cc: mysql mailing list
Subject: Re: Moving of databases from one server to another
Date: Wed, 8 Dec 2010 11:02:55 +0100
That's a very D
That's a very Debian-specific issue. The credentials for the
debian-sys-maint user are randomly generated at install, and stored in
/etc/mysql/debian.cnf. Either copy the file from the old to the new machine,
or update the user's password on the new machine to the one in the file.
On Wed, Dec 8,
copy the /etc/init.d/mysql file from your old m/c to the new and try the
start/stop.
regards
anandkl
On Wed, Dec 8, 2010 at 2:21 PM, Machiel Richards wrote:
> HI All
>
>I am hoping someone has had this before as this one is baffling me
> entirely.
>
>We did a MySQL database move from on
HI All
I am hoping someone has had this before as this one is baffling me
entirely.
We did a MySQL database move from one machine to another one last
night.
The O/S versions are the same and so are the database version
(5.1.22).
The database was installed and configured