- Plesk for Linux
Plesk is not accessible:
CONFIG_TEXT: 500 Plesk\Exception\Database
DB query failed: SQLSTATE[HY000]  Connection refused
MariaDB service cannot start with the following error in
CONFIG_TEXT: InnoDB: Error: space header page consists of zero bytes in data file ./ibdata1
/var/lib/mysql/ibdata1 is corrupted.
ibdata1 is the system tablespace for the InnoDB infrastructure. It contains several classes for information vital for InnoDB.
When the file is corrupted, the only possible solution is to restore data from backups.
Note: if you don't have root access to Plesk server via SSH, contact your hosting provider regarding the issue
Connect to the server via SSH.
Back up the
2.1. Create a new directory for storing backup:
# mkdir /root/mysql_backup
2.2. Backup data from the
/var/lib/mysql/to the newly created directory:
# cp -a /var/lib/mysql/* /root/mysql_backup/
/var/lib/mysql/ib_logfile*files by executing commands below:
# rm /var/lib/mysql/ibdata1
# rm /var/lib/mysql/ib_logfile*
Start mariadb service:
# service mariadb start
Restore Plesk related databases from a daily dump:
5.1. Switch to the directory with daily dumps:
# cd /var/lib/psa/dumps
5.2. Execute the command below to restore all system databases from the latest available daily dump
# zcat mysql.daily.dump.0.gz | plesk db
Restore user's databases from its dumps using backup manager.
Please sign in to leave a comment.