Facebook
Twitter
- Server operating system version
- CentOS 7.9.2009 x86_64
- Plesk version and microupdate number
- Plesk Obsidian 18.0.47.5
Hello everyone,
First of all, I should mention that I have examined many similar topics in the forum and tried the methods written in the topics. But in no way could I run mysql service and mariadb service properly.
First of all, I want to talk about what caused the situation.After the hard reset of the physical machine, the database crashed and I got this error after various operations. I have 16 websites in the server and I want to recover their databases.
I went through the link above and tried the steps. But I would like to state that I got the error "Unit not found" in mysql and mysqld services in the 5th stage. I tried the solution in many similar topics, but I can't find any results.
My /etc/my.cnf file ( I also tried changing the bind address to 127.0.0.1. Problem not solved)
-------------------------------------------
[mysqld]
bind-address = ::ffff:127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in Understanding and administering systemd
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
Until this stage, I thought that the problem was caused by a wrong configuration in the InnoDB engine and was damaged, but I could not come up with a solution. I would greatly appreciate it if you could help me build the build here from scratch and recover the databases.
First of all, I should mention that I have examined many similar topics in the forum and tried the methods written in the topics. But in no way could I run mysql service and mariadb service properly.
First of all, I want to talk about what caused the situation.After the hard reset of the physical machine, the database crashed and I got this error after various operations. I have 16 websites in the server and I want to recover their databases.
I went through the link above and tried the steps. But I would like to state that I got the error "Unit not found" in mysql and mysqld services in the 5th stage. I tried the solution in many similar topics, but I can't find any results.
My /etc/my.cnf file ( I also tried changing the bind address to 127.0.0.1. Problem not solved)
-------------------------------------------
[mysqld]
bind-address = ::ffff:127.0.0.1
local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in Understanding and administering systemd
[client]
socket=/var/lib/mysql/mysql.sock
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
Until this stage, I thought that the problem was caused by a wrong configuration in the InnoDB engine and was damaged, but I could not come up with a solution. I would greatly appreciate it if you could help me build the build here from scratch and recover the databases.
