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

I updated my site but I still see old pages

Make sure your files are indeed updated by checking the file time stamps. Also, you may want to...

Redirect Internet Explorer visitors to a supported browsers page

Redirect users of Internet Explorer to a supported browsers page or any other page.  To do this,...

Can you write a script for me?

We do not write scripts but will be more than happy to guide you in the right direction. Most the...

Point my domain to my wix account

How can I point my domain name to my wix.com account?To set this up you will want to login to...

How to use SharedSSL

SharedSSL is now available with our Ultra Unlimited. It is not as professional looking as having...