List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:December 8 2010 10:02am
Subject:Re: Moving of databases from one server to another
View as plain text  
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, 2010 at 9:51 AM, Machiel Richards <machielr@stripped> 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 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 on the new machine and
> was running perfectly. no issues.
>
>        Seeing that both versions would be exactly the same, we decided
> to do a full backup including the mysql database in order to preserve
> all permissions etc... and then restore this to the new machine.
>
>        The backup and restore went through without any issues
> whatsoever.
>
>        However when I used the /etc/init.d/mysql script to restart the
> database, I started getting errors during shutdown and startup
> procedure.
>
>        Despite this the database did start up and was accessible,
> however even when running /etc/init.d/mysql status command I get errors
> as below (these are the same received during startup):
>
>
>
>
>                                         /etc/init.d/mysql status
>                                        /usr/bin/mysqladmin: connect to
>                                        server at 'localhost' failed
>                                        error: 'Access denied for user
>                                        'debian-sys-maint'@'localhost'
> (using password: YES)'
>                                         *
>
>            I have tried to look on the net for answers but nothing was
> found to resolve this. I have reset the passwords for this user (also
> getting the same error for root@localhost).
>            One site also suggested correcting the password in
> the /etc/mysql/debian.cnf which I did, but still getting these messages.
>
>
>            This is a production system and I am a bit concerned to the
> fact that the startup script does not work properly.
>
>
>              Is there anyone who has had this issue before and have
> been able to resolve it?
>
>                Thank you in advance for any help on this matter.
>
>
> Regards
> Machiel
>
>
>
>
>
>


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

Thread
Moving of databases from one server to anotherMachiel Richards8 Dec
  • Re: Moving of databases from one server to anotherAnanda Kumar8 Dec
  • Re: Moving of databases from one server to anotherJohan De Meersman8 Dec
    • Re: Moving of databases from one server to anotherMachiel Richards8 Dec
      • Re: Moving of databases from one server to anotherJohan De Meersman8 Dec
        • Re: Moving of databases from one server to anotherMachiel Richards8 Dec