CODEWITHSUNDEEP
mysqldebianraspberry-pi2debian-jessie
Ahmed Benjelloun
Ahmed Benjelloun

Reputation: 43

MYSQL SERVER STOP

I get this error message when I try to start mysql :

Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details.

Please help me, otherwise I would like to save all the databases, can I do it without starting mysql?

Thank you in advance for your help =)

Upvotes: 1

Views: 159

Answers (1)

Ahmed Benjelloun
Ahmed Benjelloun

Reputation: 43

I found out the problem with this command :

sudo service mysql status

And for the backup I used this script combined with "cron job" for a backup every night :

#!/bin/sh

mysqldump --defaults-extra-file=/root/my_scripts/mp --all-databases --set-gtid-purged=OFF > /var/log/MySQL_Backup/MySQLDB.sql

exit 0

Upvotes: 1

Related Questions