Plesk is not accessible:
DB query failed: SQLSTATE[HY000]  Connection refused
MariaDB service cannot start with the following error in
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:
# zcat mysql.daily.dump.0.gz | plesk db
Restore user’s databases from its dumps using backup manager.