Easy_Way Backup MySql Database Using Cron Job скачать в хорошем качестве

Easy_Way Backup MySql Database Using Cron Job

How to Backup MySQL Database using a cron job(cPanel). To run cron jobs that back up a MySQL database you can include MySQL login information in the cron job command itself. so let's see... Firstly login into cpanel and go to advance section and click on a cron job. Add new cron job do the common setting. You can run scheduled backups of a MySQL database by creating a cron job that runs the following command: -------------------------------------------------------------------------- /usr/bin/mysqldump -u dbusername -p'dbpassword' dbname>/path/backup.sql -------------------------------------------------------------------------- Replace dbusername with the database user, dbpassword with the database user's password, dbname with the database to back up, and path with the path where you want to store the backup file. This example uses backup.sql for the backup's filename, but you can use any filename you want. The single quote (') characters around the password ensure that any special characters are processed correctly. For information about how to use cPanel to create a cron job. #Backup_MySQL_Database ================================================