17 May 2008 Support Center Home Is it possible to make a cron to backup my database at specific times? Solution Yes, this can be very useful for forum/message board sites with large databases. In your control panel under cron jobs use the following command: mysqldump --user=YOURDBUSERNAME --password=YOURDBPASSWORD --quick --add-drop-table --add-locks --extended-insert --lock-tables --all DATABASENAME | gzip > /home/username/path/to/backup/folder/databasename-`date -I`.gz Article Details Article ID: 204 Created On: 30 Aug 2005 11:13 AM This answer was helpful This answer was not helpful User Comments Add a Comment Sharing is good. If you have a comment about this entry, please feel free to share. The comments might be reviewed by our staff, and may require approval before being posted. Questions posted will not be answered. Please submit a Ticket for support requests. Fullname: Email: (Optional) Comments: Back Client Login Billing Email: Password: Remember Me: Search -- Entire Support Site -- Knowledgebase Downloads Article Options Add Comment Print Article PDF Version Email Article Add to Favorites Home | Submit a Ticket | Knowledgebase | News | Downloads Language: English (U.S.)
