Web Hosting Forum - A Web Hosting community for Webmasters


Divi WordPress Theme

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

0 Members and 1 Guest are viewing this topic.

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

Divi WordPress Theme
Tags:
 

Related Topics

  Subject / Started by Replies Last post
2 Replies
1375 Views
Last post June 15, 2013, 11:24:07 AM
by Web_news
5 Replies
1791 Views
Last post October 06, 2014, 02:44:24 PM
by Hall
3 Replies
1204 Views
Last post January 28, 2016, 12:54:19 PM
by hmb-willem
0 Replies
357 Views
Last post March 28, 2016, 04:02:26 PM
by VictorVictories
0 Replies
345 Views
Last post March 30, 2016, 05:28:12 PM
by WHUK