tutorial Create a cron to save your Db on the server

[Foster 34]

Hello,

 

This tutorial allow you to create a cron to save your db in daily.

if you want to change the delay, you can use this site to help you : https://crontab-generator.org/

 

Inside your server create a files : saveCronTabDb.sh with execute right (chmod 755)

 

#!/bin/bash


DB_USER='MyUserName'
DB_PASS='MyPassword'
DB_HOST='localhost'
DB_NAME='MyTable'

mysql -u${DB_USER} -p${DB_PASS} -h${DB_HOST} $DB_NAME < "/var/www/xxx/xxx/web8/web/myDbdirectory/myDbfilesToSave.sql"

 

Now you can create your crontab with this command: In this case all the 21hr everyday

 

* */21 * * * /var/www/xxx/xxx/web1/private/saveCronTabDb.sh > /var/www/xxx/xxx/web1/private/cron.log

 

To test your cron :

sh saveCronTabDb.sh

 

To see your cron

 

sudo crontab -l

Ah do not forget to protect your directory with an htaccess

 

# Disable directory browsing 
Options -Indexes

<Files .htaccess>
Order allow,deny
Deny from all
</Files>