Search code examples
mysqldebianraspberry-pi2debian-jessie

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 =)


Solution

  • 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