[LINUX] Auto server restart AND database backup

[strutZ]

Hey guys,

Just a basic line of code that will auto restart your server when it shuts down and take a backup of your database and name it what ever the date was that it was taken.

Step 1.
Create a folder where your 'tfs' file is located named 'database_backup'

Step 2.
Create a new text file where your 'tfs' file is located and add the following code CHANGING THE BOLD BITS TO SUIT YOU

while true; do mysqldump DATABASENAME | bzip2 -c > database_backup/backup$(date +%d-%m-%Y).sql.bz2 && ./tfs; done

Step 3.
in your console, type the following:

nano ~/.my.cnf

Step 4.
Paste the following text CHANGING THE BOLD WITH YOUR DATABASE ACCOUNT DETAILS

[mysqldump]
user=mysqluser
password=secret

Profit!

 

[Jennyx]

Thanks!

 

[Pedrook]

Do you know how you do it for the -20? In the case priority.

 

[Luiiso]

thank you !