Divi WordPress Theme

Backup MySQL database via cron on Linux

Topic: Backup MySQL database via cron on Linux  (Read 6031 times)

Offline HRamesh

  • New Member
  • *
  • Posts: 34
  • iTrader: +0/-0
    • View Profile
Backup MySQL database via cron on Linux
« on: November 09, 2008, 10:35:52 AM »
Hi,

One of the most important things for your web site is the Database. It is necessary to take the backup of your web site as well as Databases on regular basis. One of the easy sway to take backup of your MySQL database is via cron. And then you can download the backup via FTP. you can set the below cron to take MySQL backup on daily basis:

0 * * * * /usr/bin/mysqldump -u databaseusername databasename -ppassword > /path/to/take/backup.sql

The above cron will dump your MySQL database at 12 (Mid night) each day. You can set the cron time based on your convenient time.

Regards,

Ramesh
VPS Hosting - AccuWebHosting

Offline Kevin

  • Junior Guru
  • **
  • Posts: 72
  • iTrader: +4/-0
    • View Profile
Re: Backup MySQL database via cron on Linux
« Reply #1 on: November 25, 2008, 10:04:22 AM »
Hi Ramesh,

Thanks for sharing it.

Kevin
Shopify Divi WordPress Theme
Tags:

Backup Outlook Express

Started by TechBoard Email Management Software & Email Clients

Replies: 9
Views: 7135
Last post September 18, 2014, 05:54:08 PM
by timothyjones
cPanel - WHM Backup problem

Started by HRameshBoard cPanel/WHM

Replies: 4
Views: 5295
Last post July 20, 2010, 11:43:20 AM
by webhosting.am
Website Security Plan Launched by Online Backup Vault with G

Started by jeromeBoard PHP

Replies: 1
Views: 4902
Last post January 23, 2012, 10:36:55 PM
by markarthur
[eukhost] 50% OFF on Managed WordPress Hosting | Free Domain, SSL, Backup

Started by Wilsonjacob45Board Web Hosting Offers

Replies: 0
Views: 29
Last post July 21, 2021, 06:29:24 PM
by Wilsonjacob45
GroomHost.com - USA : $2.50p/m = Domain, SSD, Daily Backup, 24/7 Help - Perfect

Started by GroomHostBoard Web Hosting Offers

Replies: 0
Views: 1330
Last post March 24, 2015, 06:17:21 PM
by GroomHost