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.

Where are mysql databases located?

Discussion in 'Database Discussions' 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:
    13
    Likes Received:
    4
    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.
     
    RadWebHosting likes this.
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,794
    Likes Received:
    1,712
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,794
    Likes Received:
    1,712
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
  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 Forums Analyst
    Staff Member

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

    Thank you.
     
Loading...

Share This Page