Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Legacy backup restoration mysql error

Discussion in 'Data Protection' started by zambara, Apr 30, 2017.

  1. zambara

    zambara Member

    Joined:
    Jun 10, 2008
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    51
    Hello,

    I am running
    • CENTOS 6.9 x86_64 virtuozzo – cpanel
    • cPanel & WHM 64.0 (build 18)
    I have a problem with several account restore. I receive the following error:

    Code:
    Mysql
    Preparing MySQL restore …
    Databases owned by “infocivi” will be overwritten on conflict.
    The system will restore the database “infocivi_wpdb” as “infocivi_wpdb2” because another cPanel user owns “infocivi_wpdb”.
    Restoring MySQL databases
    Restoring the database “infocivi_wpdb” as “infocivi_wpdb2” …
    The system has created a new database named “infocivi_wpdb2”.
    Granting “infocivi” access to “infocivi_wpdb2” with temporary password …
    The system failed to reinstall the MySQL database “infocivi_wpdb” as “infocivi_wpdb2” because of an error: Failed to grant “infocivi” access to “infocivi_wpdb2”: The system could not perform “GRANT” statements on the database “infocivi_wpdb2” for the user “infocivi” due to an error: (XID 5jbv53) The system received an error from the “MySQL” database “mysql”: ER_PASSWORD_NO_MATCH (Can't find any matching row in the user table)
    Restoring MySQL database mappings
    Restoring MySQL privileges
    Database users owned by “infocivi” will be overwritten on conflict.
    The system will restore the database user “infocivi” as “infocivi2” because another cPanel user owns “infocivi”.
    Restoring MySQL grants
    Restoring MySQL access hosts
    Storing MySQL Grants
    
    And the database is empty. I got the database from the backup file, manually restored and give manually grant permissions but I want to fix this error for future restores.

    Thank you for the help!
    /Dani
     
    #1 zambara, Apr 30, 2017
    Last edited by a moderator: Apr 30, 2017
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,488
    Likes Received:
    60
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi,

    The system will restore the database “infocivi_wpdb” as “infocivi_wpdb2” because another cPanel user owns “infocivi_wpdb”.
    --> There seems to be some issue with the account backup, the database is written different due to it not able to get the ownership check through it..

    Can you try taking the backup of the account and restoring it again see if you get the same error on it..
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you review the /etc/my.cnf file on this system and verify if an entry exists for skip_name_resolve?

    Thank you.
     
Loading...

Share This Page