Hi, can somebody tell me how can I find a correct path for MySQL start ?
in MySQL configuration page I have this:
System configuration
Path to mysqlshow command /usr/bin/mysqlshow
Path to mysqladmin command /usr/bin/mysqladmin
Path to mysql command /usr/bin/mysql
Path to mysqldump command /usr/bin/mysqldump
Path to mysqlimport command /usr/bin/mysqlimport
MySQL Unix socket /var/lib/mysql/mysql.sock
Databases files directory /var/lib/mysql
Path to MySQL databases directory /var/lib/mysql
I need to know the correct path in order to automaticaly start the server when the server goes down in Others - System and Server Status Monitor page:
I’ve tried a lot of paths as:
as /var/lib/mysql start or /usr/bin/systemctl mariadb start , but no one works, the system only sends me an email but I have to start it manualy.
Recently I have some problems with Error Establishing a Database Connection and before I will understand which plugin (wordpress) once a week force the server to go down, I want to automaticaly restart it in the moment the webmin sends me an email.
I have also installed Virtualmin.
Thanks for your reply, but sorry I am a newbie, can You explain better what You mean by "try object returned by the “> which mysql” command.
How can I try it?
Ok, at your command prompt, just type “which mysql” and it will tell you which binary is the one the system uses. It shows the full path to it. “Which” works for many installed programs!
Anyone can tell me that correct path?
I have also another question, once a week my MySQL goes down, it is probably because of one of my wordpress websites using a lot of plugins, does exists some error logs which could tell me what plugin, file, database error cause database going down? If yes where can I find it?