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.

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.
     
    #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.
     
    #3 nxweb, Oct 30, 2008
(You must log in or sign up to post here.)
Loading...
Similar Threads - Restore MySQL databases
  1. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    191
    Naila
    Jun 22, 2017
  2. djbaxter

    SOLVED The MySQL restore process died from the “SEGV” signal.

    djbaxter, Mar 11, 2017, in forum: Data Protection
    Replies:
    8
    Views:
    1,310
    cPanelMichael
    Apr 4, 2017
  3. cornishman33

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    400
    cPanelMichael
    Oct 11, 2016
  4. gnusys

    cPanel account restore does not work for remote mysql profile

    gnusys, Feb 6, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    762
    cPanelMichael
    Feb 8, 2016
  5. mindnetcombr

    Legacy restore, why copy twice?

    mindnetcombr, Aug 15, 2017, in forum: Data Protection
    Replies:
    12
    Views:
    88
    mindnetcombr
    Aug 19, 2017 at 7:06 AM

Share This Page