Foster 65 Posted August 22, 2019 Share 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> 2 1 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.