LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-04-2018, 08:16 PM   #1
sub320
Member
 
Registered: Jan 2016
Posts: 116

Rep: Reputation: 3
mysql differential backup


We have mysql database , our daily backup method is use mysqldump command to export all data and gzip it , as the data size is very large , we want to use differential backup .

does mysql support differential backup ? any command can be used to export differential data ?

thanks
 
Old 06-04-2018, 08:27 PM   #2
scasey
Senior Member
 
Registered: Feb 2013
Location: Tucson, AZ, USA
Distribution: CentOS 7.5
Posts: 1,414

Rep: Reputation: 481Reputation: 481Reputation: 481Reputation: 481Reputation: 481
When searching for “mysql differential backup” the first response is the MySQL instructions for that.
Please read that.https://dev.mysql.com/doc/mysql-ente...cremental.html

Last edited by scasey; 06-04-2018 at 08:40 PM.
 
Old 06-05-2018, 11:24 AM   #3
TenTenths
Senior Member
 
Registered: Aug 2011
Location: Dublin
Distribution: Centos 5 / 6 / 7
Posts: 2,718

Rep: Reputation: 1037Reputation: 1037Reputation: 1037Reputation: 1037Reputation: 1037Reputation: 1037Reputation: 1037Reputation: 1037
Personally I use master/slave replication and then take a full backup from the slave, that way the primary database won't be impacted and the slave will catch up once the backup has completed.
 
Old 06-05-2018, 05:31 PM   #4
scasey
Senior Member
 
Registered: Feb 2013
Location: Tucson, AZ, USA
Distribution: CentOS 7.5
Posts: 1,414

Rep: Reputation: 481Reputation: 481Reputation: 481Reputation: 481Reputation: 481
^^ Master/slave is an excellent idea.
On my most recent gig, the DBA's used incremental backups of Oracle databases because they were HUGE! (Data warehouse DB's). Even then, the daily backups took most of an hour.

A factor to consider with incremental database backups is the challenges of restoring from backup. At that place, a restoration could take up to two days (!!) Just food for thought...
 
Old 06-06-2018, 12:09 PM   #5
Habitual
LQ Veteran
 
Registered: Jan 2011
Location: Yawnstown, Ohio
Distribution: High Sierra
Posts: 9,107
Blog Entries: 37

Rep: Reputation: Disabled
export|import is faster (for most small sites.)
Oracle? Ack! I migrated 8i on NT4.0 to Sun Server with zero downtime using the oracle equivalents of dump and import.
A secondary stand-by mysql server instance is never a bad idea, even if one never has to use it after testing restore twice.

Why is "size" an issue in this day and age?
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for a differential backup script Kiran501 Linux - Newbie 7 09-17-2007 06:13 AM
differential backup mithridates Fedora 1 09-11-2007 07:52 PM
Script for Differential Backup ????? ajeetraina Programming 3 08-01-2007 03:46 PM
KDar differential backup problem krisbitner Linux - General 0 10-21-2006 03:25 PM
differential backup package? taiwf Linux - Software 1 04-10-2006 06:28 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:09 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration