Mysql Database restore / reinstall / rebuild CentOs Cpanel

Entelekta

• August 09, 2023 05:16

Hello i need your help After turning off the server and turning it on again, my MySQL database no longer works. How can I revive mysql with ERROR 2002 (HY000)?: Scroll down for pics Root: systemctl status mysqld.service [QUOTE] ? mysqld.service - MySQL Server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Drop-In: /etc/systemd/system/mysqld.service.d ??limits.conf Active: failed (Result: start-limit) since Mi 2023-08-09 06:03:03 EDT; 4min 24s ago Docs: man:mysqld(8) 83801 -server.jpg">83809

• 

  ffeingol

  • August 09, 2023 13:43

  Your going to have to provide more details from the MySQL log file. It's typically in /var/log/mysqld.log. The file /var/lib/mysql/mysql.sock (the socket that MySQL creates) is normally 0 bytes.

  0
• 

  Entelekta

  • August 09, 2023 20:15

  Thanks for reply! ;) [QUOTE][COLOR=rgb(243, 121, 52)][root@prof-vds-1 ~]# mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
  It was over 160 MB I deleted mysqld.log contents and systemctl restart mysqld Download Full 1 file " 522,6 KB Title: new_mysqld.log [QUOTE] MySQL Bugs. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: MySQL :: MySQL 8.1 Reference Manual :: B.3.3.3 What to Do If MySQL Keeps Crashing contains information that should help you find out what is causing the crash.
  

  0
• 

  cPRex Jurassic Moderator

  • August 09, 2023 20:46

  Unfortunately that isn't good news. I'd recommend working through this if you feel comfortable with the process, or reaching out to an experienced database administrator to keep data loss to a minimum.

  0
• 

  Entelekta

  • August 09, 2023 21:06

  Could you do that for me? for a fee ? :)

  0
• 

  cPRex Jurassic Moderator

  • August 09, 2023 21:18

  Unfortunately we don't provide that service on our end. There are administrators you can hire at though!

  0

Please sign in to leave a comment.