Is it possible to make a cron to backup my database at specific times?

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

  • 420 Users Found This Useful

Was this answer helpful?

Related Articles

Convert PDF to HTML Service

To convert your PDF files to html try using the following converter tool from Adobe:...

I am unable to delete a file

This can occur for several reasons. With our service, if a directory of a script was found to be...

View your website in older browser versions

As developers and webmasters it is always important to make sure your website works in several...

Error 508 / 503 - Resource Limit Reached

To help maintain the stability of servers and keep websites fast, UltraWebHosting has resource...

Redirect http to https and www

To forward a website to use both www. and https:// use the following in an .htaccess file:...