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

  • 418 Users Found This Useful

Was this answer helpful?

Related Articles

Disable error_log via .htaccess

Prevent public display of PHP errors via htaccess# supress php errorsphp_flag...

https:// with Weebly

To enable and force https:// with your Weebly website, be sure to go into your editor area,...

Creating a Form Button

Sometimes all you need is a simple button. The following pages are pretty useful tools for...

What are these vt directories?

Those are FrontPage extension directories. If you have and no longer need them you can uninstall...

Error 508 / 503 - Resource Limit Reached

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