Re: Moving of databases from one server to another

2010-12-08 Thread Machiel Richards
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

Re: Moving of databases from one server to another

2010-12-08 Thread Johan De Meersman
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

Re: Moving of databases from one server to another

2010-12-08 Thread Machiel Richards
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

Re: Moving of databases from one server to another

2010-12-08 Thread Johan De Meersman
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,

Re: Moving of databases from one server to another

2010-12-08 Thread Ananda Kumar
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

Moving of databases from one server to another

2010-12-08 Thread Machiel Richards
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