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!

Restore MySQL databases

Discussion in 'General Discussion' started by markerpower, Oct 29, 2008.

  1. markerpower

    markerpower Member

    Joined:
    Mar 16, 2005
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    151
    Hello,

    I am trying to restore some databases. I copied /var/lib/mysql to mysql on another server. When I view the databases they are listed, but the usernames created with the databases are not listed and are not linked with the databases.
    Are the usernames stored somewhere else?
     
    #1 markerpower, Oct 29, 2008
  2. jBillu

    jBillu Member

    Joined:
    Oct 21, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    51
    Hi,

    The database users are stored in 'user' table of 'mysql' database. Please make sure that has been copied completely and ownerships of the databases are correct. The ownerships must be 'mysql.mysql'.

    Hope that will help.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 jBillu, Oct 29, 2008
  3. nxweb

    nxweb Active Member

    Joined:
    Oct 29, 2008
    Messages:
    37
    Likes Received:
    0
    Trophy Points:
    56
    Also, doing a directory copy is not the best idea... a lot of scripts like vbulletin etc will leave the tables "in use" and you will need to repair them. Also, if you had any innodb tables you are probably missing the ibdata files.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #3 nxweb, Oct 30, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - Restore MySQL databases
  1. sodapopinski

    Restore mysql database to server with maria DB?

    sodapopinski, Oct 19, 2017, in forum: Database Discussion
    Replies:
    1
    Views:
    672
    cPWilliamL
    Oct 19, 2017
  2. postcd

    Restore backups/import without MySQL resetting mysql passwords?

    postcd, Aug 30, 2017, in forum: Data Protection
    Replies:
    5
    Views:
    986
    cPanelMichael
    Mar 22, 2018
  3. postcd

    How to restore all files backups and a mysql separately?

    postcd, Aug 29, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    895
    cPanelMichael
    Aug 31, 2017
  4. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017, in forum: Database Discussion
    Replies:
    4
    Views:
    947
    Naila
    Jun 22, 2017
  5. uk01

    Unble to Restore Database from R1soft Backup

    uk01, May 21, 2019 at 9:54 PM, in forum: Data Protection
    Replies:
    3
    Views:
    110
    cPanelLauren
    May 22, 2019 at 12:16 PM

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice