cPanel is broken and outdated - How to extract databases

glmanager

• May 28, 2024 05:17
• Edited

Hi All,

I have cPanel server running on Linux CentOS 7.

From what i can see CentOS 7 / cPanel  110.0.33 / PHP 7.2 are outdated.

I can't use Wordpress Manager or PHPMyAdmin.

I tried Full Backup but it ends up with timeout.

How else I can retrieve databases?

• 

  quietFinn

  • May 28, 2024 07:07
  • Edited

  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

  • May 28, 2024 06:43

  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

  • May 28, 2024 07:08

  Try with FTP.

   

  0
• 

  glmanager

  • May 28, 2024 07:54
  • Edited

  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

  • May 28, 2024 13:31

  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.