MySQL Forums
Forum List  »  Newbie

Mysql server doesn't start after moving data dir
Posted by: Wim NA
Date: February 22, 2018 06:35PM

System: Debian Jessie, MySQL 5.5.59.

I tried moving the data directory with rsync -av and adjusted my.cnf in /etc/mysql/my.cnf

After that,the mysql server wouldn't start. So I moved the data back to /var/lib/mysql/

But even after that, I can't get the server to start. The log file at /var/log/mysl/ is empty, but has today's date and neither systemctl status mysql.service or 'journalctl -xn give any info, except this:

mysql.service - LSB: Start and stop the mysql database server daemon
   Loaded: loaded (/etc/init.d/mysql)
   Active: failed (Result: exit-code) since Fri 2018-02-23 01:12:12 CET; 18min ago
  Process: 9939 ExecStop=/etc/init.d/mysql stop (code=exited, status=0/SUCCESS)
  Process: 11970 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

I've checked permissions on /var/lib/mysql/ and they are mysql:mysql.

The only thing I noticed wrong is that nested copies of the data directory where in /tmp/. I've deleted those.

I am at a loss. Anybody any idea what' going wrong here?

Options: ReplyQuote


Subject
Written By
Posted
Mysql server doesn't start after moving data dir
February 22, 2018 06:35PM
February 24, 2018 04:13PM
February 25, 2018 04:50AM
February 25, 2018 12:32PM
February 25, 2018 12:45PM
February 25, 2018 01:51PM
February 25, 2018 07:16PM
February 26, 2018 02:51PM
February 26, 2018 03:09PM
February 26, 2018 06:21PM
February 26, 2018 11:00PM
February 27, 2018 05:20PM
February 27, 2018 12:03PM
February 27, 2018 02:21PM
February 27, 2018 05:25PM
February 27, 2018 03:40PM
February 27, 2018 05:31PM


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.