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.

mysql databases not shown in cpanel

Discussion in 'Database Discussions' started by Rahimian, Nov 1, 2014.

  1. Rahimian

    Rahimian Member

    Joined:
    Apr 23, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    hi to all
    i migrate all of my websites from old cpanel server to new cpanel server
    i migrate progress i dont see any warnings and errors and the migration successfully
    after migration i checked the new server and then i see /var/lib/mysql folder is emtpy and all websites have mysql problem.
    i transfer /var/lib/mysql folder from old server to new server and then mysql problem for websites is ok .
    but now i see that mysqldatabases in cpanel not shown .
    how can i solve this problem?
     
    #1 Rahimian, Nov 1, 2014
  2. Sys Admin

    Sys Admin Well-Known Member

    Joined:
    Apr 29, 2007
    Messages:
    67
    Likes Received:
    0
    Trophy Points:
    156
    cPanel Access Level:
    Root Administrator
    So, You moved the /var/lib/mysql manually? I would recommend moving the accounts again from your old server.
     
    #2 Sys Admin, Nov 1, 2014
  3. Rahimian

    Rahimian Member

    Joined:
    Apr 23, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    thanks for your replay .
    i dont have any access to old server . becuase the old server has been terminated .
    how can i solve the problem ?
    thanks
     
    #3 Rahimian, Nov 1, 2014
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    35,741
    Likes Received:
    1,143
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    You can assign database and database user ownership to an account via:

    "WHM Home » SQL Services » Database Map Tool"

    Thank you.
     
    #4 cPanelMichael, Nov 3, 2014
(You must log in or sign up to post here.)
Loading...
Similar Threads - mysql databases shown
  1. kiopeed

    SOLVED Create new mysql Databases command/shell?

    kiopeed, Jan 11, 2017, in forum: Database Discussions
    Replies:
    11
    Views:
    750
    cPanelMichael
    Jan 30, 2017
  2. Nirjonadda

    SOLVED Deprecated MySQL databases

    Nirjonadda, Jan 6, 2017, in forum: Database Discussions
    Replies:
    12
    Views:
    1,625
    cPanelMichael
    Mar 9, 2017
  3. Musthafa

    SOLVED Restoring MySQL Databases Question

    Musthafa, Dec 15, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    331
    SysSachin
    Dec 21, 2016
  4. Map-it

    MySQL databases missing but they exist in phpadmin

    Map-it, Nov 9, 2016, in forum: General Discussion
    Replies:
    1
    Views:
    248
    cPanelMichael
    Nov 9, 2016
  5. kavos1332

    cPanel does not backup MySQL databases

    kavos1332, Oct 14, 2016, in forum: Data Protection
    Replies:
    3
    Views:
    550
    cPanelMichael
    Oct 14, 2016

Share This Page