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

Inode issues

There are many issues that can arise from reaching your inode limit. The inode limit is the total...

Can I change my username?

Usernames are setup in the manner for security. Most programs will allow you to save the...

Creating and Submitting a Google Sitemap

Creating a Google sitemap can be easy and beneficial. By using one, you are pushing a full list...

Change your Websites Favorite Icon

How to change your website's icon for your internet browser. Create a 16x16 pixel icon image...

https:// with Weebly

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