Backup Your Hosting Database Via Cron Job

Get Your Database Hosting Address , Name , Username and Password

mysqldump command is used for dumping a mysql database.

Set up a cron job with this command as follows,

Please change required parameter with your own.

Syntax:

mysqldump -h (hostname) -u (user-name) -–password=(password) (database-name) > (full path of backup file)

Example:

mysqldump -h p45mysql7.secureserver.net -u testebdb -–password=password mytestbdb > /home/content/q/a/b/testchep/html/backups/daily.sql

source

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s