> " intermittent connection problems (error 2013)"
>
> Look at SHOW PROCESSLIST; when you're having a connection problem. If you
> see lots of "unathenticated user" in the list, then it means you're having
> DNS problems.
>
> Typically the best way to handle this is to set skip-name-resolve,
Greetings to all,
Can I migrate slave databases between slave servers?
Imagine the following scenario: I have one master database server with
10 databases. I also have two slave database servers, one replicating
5 of the 10 databases, the other replicating the other 5 databases.
Can I migrate on
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 1
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 Debian-spec
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
