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

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...

SSL - Creating a CSR in Windows 2003

Creating the CSR IIS Windows 2003 or 2000 Server: From Administrative Tools, run the Internet...

Why is the server load status red?

The server load status will be red if the server is under a little more stress than usual. This...

View your website in older browser versions

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

How can I change the default page / document?

Create a .htaccess file, include the below information into it and upload it to the public_html...