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?