Database error

deepy

• November 14, 2016 23:52

Hi I am experiencing serious problem on my website. My website is down due to "database error" I have checked the server status and showing the below error message /dev/sda7 /var 100% (133,757,300 of 140,980,692) Also mySQL databse from cPanel showing " MySQL server currently offline" See the attached error message. Kindly help me to fix the issue regards dp

• 

  SysSachin

  • November 15, 2016 07:19

  Your /var partition is 100% full and because of that MySQL service is done on the server. If you have free space on your another partition (/home) then you can move your MySQL directory to your /home partition 1. Take a full backup of your all database.
  mysqldump --all-databases | gzip > /home/alldatabases.sql.gz
  2. Disable MySQL service through WHM > Service Manager for MySQL and save the area, So that monitor service will not start MySQL service while moving MySQL directory to other partition 3. Stop MySQL service
  /etc/init.d/mysql stop
  4. Move your MySQL directory to /home and with following command.
  mkdir /home/var_mysql mv /var/lib/mysql /home/var_mysql chown -R mysql:mysql /home/var_mysql/mysql ln -s /home/var_mysql/mysql /var/lib/mysql /etc/init.d/mysql start
  5. Enable MySQL service through WHM > Service Manager

  0
• 

  cPanelMichael

  • November 15, 2016 15:38

  Hello, I recommend checking to see if there's anything in the /var partition you can remove before moving MySQL to another partition. The following document provides commands you can use to see what's taking up the space: How to Manage your Hard Drive Space - cPanel Knowledge Base - cPanel Documentation Thank you.

  0

Please sign in to leave a comment.