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

Password Protect Directories

Within control panel select Password Protection. Select the directory you would like to protect....

What perl modules are installed on the server?

You can get a complete list of the modules that are installed by going to the control panel and...

Add Flash Chat to your Website

We ran into this website recently which allows you to easily insert a flash chat room into your...

osCommerce password reset

How to reset your osCommerce admin login... You can reset your osCommerce administrative login...

My pages are updating/refreshing slowly

Refresh is immediate on the server. When a file is updated and uploaded it is there. If you are...