Moving of databases from one server to another

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

Re: Moving of databases from one server to another

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 machi...@rdc.co.za wrote: HI All I am hoping someone has had this before as this one is baffling me entirely. We did a MySQL database

Re: Moving of databases from one server to another

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

Re: Moving of databases from one server to another

Hi Johan Would the server require a restart after this or not? Machiel -Original Message- From: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: Moving of databases from one server to another Date:

Re: Moving of databases from one server to another

On Wed, Dec 8, 2010 at 11:05 AM, Machiel Richards machi...@rdc.co.zawrote: 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

Re: Moving of databases from one server to another

HI Johan Thank you for the advice... Problem resolved. Regards Machiel -Original Message- From: Johan De Meersman vegiv...@tuxera.be To: Machiel Richards machi...@rdc.co.za Cc: mysql mailing list mysql@lists.mysql.com Subject: Re: Moving of databases from one server to another Date:

migrating a split replication

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

RE: Bind-address use?

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, and using