Issue ERROR 2013(HY000) Lost connection to MySQL server when trying to load a db backup

[bruno97]

running the command to restore ab DB backup brings me to this:

zcat mysql.daily.dump.8.gz | plesk db
ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 104
exit status 1

 

[IgorG]

Are you sure that MySQL service is up and running at least?

 

[bruno97]

I checked the status of maraidb and that says its runnig, when I check the status of mysql and mysqld it returns:


# service mysql status
Redirecting to /bin/systemctl status mysql.service
Unit mysql.service could not be found.

# service mysqld status
Redirecting to /bin/systemctl status mysqld.service
Unit mysqld.service could not be found.

 

[bruno97]

I also tried to start the two services and it responds with the same message:

Failed to start mysql.service: Unit not found.

 

[WikiTech]

I found something in Forum about the same error. Maybe this will help you.

Resolved - MYSQL server loses connection while trying to drop psa database to import dump.

Title might be a bit misleading but thats where I was at trying to fix it last. I have tried all manner of things Tried to restore dump Reinstalled mysql Tried to drop PSA to import the new dump Mariadb is latest, no upgrade available. Mysql folder backed up and so are the dumps just incase...

talk.plesk.com