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!

Where are mysql databases located?

Discussion in 'Database Discussion' started by mysql4all, Sep 19, 2017.

  1. mysql4all

    mysql4all Registered

    Joined:
    Sep 19, 2017
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    France
    cPanel Access Level:
    Root Administrator
    Hello guys , my cpanel license is expired and I don't want to renew it . I need to have a backup of one of my databases . I wonder where are the databases located in CentOS ? I have root access . Also is it possible to have 3-4 days free license ? thanks
     
  2. kssuhesh

    kssuhesh Member

    Joined:
    Jan 11, 2009
    Messages:
    16
    Likes Received:
    5
    Trophy Points:
    128
    Location:
    Kochi
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    Database raw files are located in "/var/lib/mysql" directory. You can take backup of the mysql databases using the following command.

    mysqldump db_name > db_name.sql

    Regarding the license, are you going to migrate the accounts to a new server ? If yes, you can take backups from backend and restore it in new server. Or renew license for one more month and proceed with the migration. So you will get one month to schedule and do the migration.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    RadWebHosting likes this.
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,400
    Likes Received:
    1,953
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    The previous post is correct. As far as the license, you'd need to direct all license questions to billing@cpanel.net via email.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Apoorv Bansal

    Apoorv Bansal Registered

    Joined:
    Mar 22, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    India
    cPanel Access Level:
    Website Owner
    Hey can you tell me where can i find my sql database files to edit the tables in cpanel
     
    #4 Apoorv Bansal, Mar 22, 2018
    Last edited by a moderator: Mar 22, 2018
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,400
    Likes Received:
    1,953
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    You can use phpMyAdmin to manage or edit your databases. It should be listed as an option under the Databases section in cPanel.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Sabkuchh89

    Sabkuchh89 Registered

    Joined:
    Apr 4, 2018
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    india
    cPanel Access Level:
    Website Owner
    Hi, im also not able to find and locate my sql data file pls help me... my site is [removed]
     
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,400
    Likes Received:
    1,953
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    As a website owner without root access, you'd need to manage your databases via "cPanel >> phpMyAdmin".

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice