T TheUltimate The Ultimate Member Aug 21, 2006 94 0 0 www.theultimatepublishing.com Jul 31, 2008 #1 Is there anywhere I can find a wp plugin that automatically backs up mysql database on a preset schedule?
Is there anywhere I can find a wp plugin that automatically backs up mysql database on a preset schedule?
C casidnet New member Nov 23, 2006 164 6 0 Jul 31, 2008 #2 If you don't mind using a cron you could just put this in your crontab on the desired schedule. mysqldump -uusername -ppassword wordpress_db_name > wordpress_backup_`date '+%y%m%d'`.sql would work just as well as any plugin and easier.
If you don't mind using a cron you could just put this in your crontab on the desired schedule. mysqldump -uusername -ppassword wordpress_db_name > wordpress_backup_`date '+%y%m%d'`.sql would work just as well as any plugin and easier.
T TheUltimate The Ultimate Member Aug 21, 2006 94 0 0 www.theultimatepublishing.com Jul 31, 2008 #3 Got it! Thanks!
LotsOfZeros ^^^ Bi-Winning ^^^ Feb 9, 2008 4,649 118 0 www.makemoniesonline.com Jul 31, 2008 #4 casidnet said: If you don't mind using a cron you could just put this in your crontab on the desired schedule. mysqldump -uusername -ppassword wordpress_db_name > wordpress_backup_`date '+%y%m%d'`.sql would work just as well as any plugin and easier. Click to expand... what location does this save it to? public_html root folder?
casidnet said: If you don't mind using a cron you could just put this in your crontab on the desired schedule. mysqldump -uusername -ppassword wordpress_db_name > wordpress_backup_`date '+%y%m%d'`.sql would work just as well as any plugin and easier. Click to expand... what location does this save it to? public_html root folder?
C casidnet New member Nov 23, 2006 164 6 0 Jul 31, 2008 #5 LotsOfZeros said: what location does this save it to? public_html root folder? Click to expand... Depends on your system. It would be better to put an absolute path at the end and on the mysqldump command before putting it into production use.
LotsOfZeros said: what location does this save it to? public_html root folder? Click to expand... Depends on your system. It would be better to put an absolute path at the end and on the mysqldump command before putting it into production use.