Thanks for the info dude...![]()
You can set the Cron job to generate the database backup for your database.
Here's For Dumping MySQL DB To File In Your Server
1) Cron job syntax to take database backup in simple .sql format is as follows
2) To compress the database backup file in the gz format.* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword > /path of the database store file.sql
3) To compress the database backup in the bz2 format* * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword|gzip > /path of the database store file.gz
* * * * * /usr/bin/mysqldump -u datbaseusername databasename -pdatbasepassword|bzip2 -c > /path of the database store file .bz2
Thanks for the info dude...![]()
Thanks, I still find out how to dump mysql db to email
Nice informatie post, thanks @fajarmulya
There are currently 1 users browsing this thread. (0 members and 1 guests)
Actions : (View-Readers)
Bookmarks