| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Ubuntu Linux 20.04.4 |
| Webmin version | 1.990 |
| Virtualmin version | 6.17-3 Pro |
| Related packages | SUGGESTED |
My problem is:
The full MySQL error message was : DBI connect failed : Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
Please Help Me
Hello,
What if you try manually restarting MySQL service by going to Webmin Servers ⇾ MySQL Database Server page or by running:
systemctl restart mysql
Thank you for your awnser, but i get the follow error:
Setting up mysql-server-8.0 (8.0.29-0ubuntu0.20.04.3) …
Specified filename /var/lib/mysql/ibdata1 does not exist.
2022-05-05T13:11:54.595611Z 0 [ERROR] [MY-011065] [Server] Unable to determine if daemon is running: No such file or directory (rc=0).
2022-05-05T13:11:54.595658Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
Warning: Unable to start the server.
Job for mysql.service failed because the control process exited with error code.
See “systemctl status mysql.service” and “journalctl -xe” for details.
invoke-rc.d: initscript mysql, action “start” failed.
My error list:
Setting up mysql-server-8.0 (8.0.29-0ubuntu0.20.04.3) …
Specified filename /var/lib/mysql/ibdata1 does not exist.
2022-05-05T13:11:54.595611Z 0 [ERROR] [MY-011065] [Server] Unable to determine if daemon is running: No such file or directory (rc=0).
2022-05-05T13:11:54.595658Z 0 [ERROR] [MY-010946] [Server] Failed to start mysqld daemon. Check mysqld error log.
Warning: Unable to start the server.
Job for mysql.service failed because the control process exited with error code.
See “systemctl status mysql.service” and “journalctl -xe” for details.
invoke-rc.d: initscript mysql, action “start” failed.
It seems that MySQL installation got corrupt/broken. It’s not clear what went wrong.
Do you have any critical data (databases) in it?
Please tell us more about what happened before this issue popped up? Perhaps, package upgrades process went incorrectly?
hi again, Do you have any critical data (databases) in it? yes.
I have three moodles that are in operation through virtual server in virtualmin, I must solve it without losing the moodles.
Is there a way to backup everything, to reinstall my entire server and use my backup and my moodle sites are whole in a few hours?
Please tell us more about what happened before this issue popped up? Perhaps, package upgrades process went incorrectly?
Before this error, it happened to me that the mysql server stopped, but I only needed to go to start it and run mysql again, but since yesterday at approximately 8:00 pm this was no longer possible and I get these errors, previously with restarting the whole server mysql was working again but now no luck.
I have three moodles that are in operation through virtual server in virtualmin, I must solve it without losing the moodles.
This may be more complex task depending on what happened. The easiest way would be restoring from a previous backup or snapshot.
Is there a way to backup everything, to reinstall my entire server and use my backup and my moodle sites are whole in a few hours?
In order to backup a database, MySQL should be running. It depends if /var/lib/mysql was corrupt. You could try to spin up a new system, install Virtualmin using install.sh script, stop mysql.service and rsync using archive mode (to preserve permission) MySQL /var/lib/mysql directory from old server to the new.
Although, I would first suggest trying the following:
dpkg --configure -a
apt-get install --reinstall mysql-client mysql-common mysql-server mysql-server
Also, have a look at what apt-get update and apt-get upgrade return.
thanks, i will do
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.