Skip to main content
cPanel Technical Support has been heavily impacted by hurricane Beryl and our ability to respond to tickets has been hindered as a result. We appreciate your understanding and patience as we address these delays.

cPanel is broken and outdated - How to extract databases

Comments

5 comments

  • quietFinn

    Does this work?
    cPanel -> Backup -> Download a Database Backup

    If you have root access you can do:
    mysqldump user_database > user_database.sql

     

    1
  • glmanager

    Hi quietFinn

    Does this work?
    cPanel -> Backup -> Download a Database Backup

    For some reason when I download files they're only 20KB and empty

    If you have root access you can do:
    mysqldump user_database > user_databe.sql

    I have root access.

    If I run mysqldump user_database > user_databe.sql how can I get it then.

    Sorry if it is a silly question.

    Just never worked with Linux.

    0
  • quietFinn

    Try with FTP.

     

    0
  • glmanager

    Just tried.

    [root@cpanel ~]# mysqldump user_database > user_database.sql

    mysqldump: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect

    0
  • cPRex Jurassic Moderator

    That's a separate issue then, and explains why you're having issues with the machine, as the root user isn't able to connect to MySQL.  Can you try using the WHM >> Change Database Root Password tool to reset that password, and then see if you can connect properly?

    0

Please sign in to leave a comment.