MySQL Forums
Forum List  »  Install & Repo

MySQL service will not start
Posted by: Olaf Koestner
Date: May 25, 2016 05:44AM

Hi,

on my RasPi I installed MySQL. Unfortunately I will now have to move all databases to another path (NFS mounted NAS).

Basically I did the following:

- stop the mysql Service
- move all files from /var/lib/mysql to /home/pi/nas/db
- updated the datadir variable in the /etc/mysql/my.cnf


But when starting the service I will now see the following error messages in syslog:

May 25 13:35:50 maschine /etc/init.d/mysql[32232]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
May 25 13:35:50 maschine /etc/init.d/mysql[32232]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
May 25 13:35:50 maschine /etc/init.d/mysql[32232]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
May 25 13:35:50 maschine /etc/init.d/mysql[32232]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
May 25 13:35:50 maschine /etc/init.d/mysql[32232]:
May 25 13:35:50 maschine mysql[31497]: Starting MySQL database server: mysqld . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . failed!
May 25 13:35:50 maschine systemd[1]: mysql.service: control process exited, code=exited status=1
May 25 13:35:50 maschine systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
May 25 13:35:50 maschine systemd[1]: Unit mysql.service entered failed state.
May 25 13:39:01 maschine CRON[32292]: (root) CMD ( [ -x /usr/lib/php5/sessionclean ] && /usr/lib/php5/sessionclean)


And the service will not start.
What do I need to do to get the service back running? How can I check if the permissions to the new path work properly?



Best regards,
Olaf

Options: ReplyQuote


Subject
Written By
Posted
MySQL service will not start
May 25, 2016 05:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.