LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Fedora
User Name
Password
Fedora This forum is for the discussion of the Fedora Project.

Notices

Reply
 
Search this Thread
Old 09-11-2007, 07:03 AM   #1
mithridates
LQ Newbie
 
Registered: Mar 2004
Distribution: SlackwarE
Posts: 8

Rep: Reputation: 0
Question differential backup


hello guys
i want to take differential backup of mysql but i can,t do it if anybody knows how to take differential please tell me ....

thank before
( do not need full or incremental i have do it and take both full and incremental ) i want diffrential backup

tnx tnx
 
Old 09-11-2007, 07:52 PM   #2
choogendyk
Senior Member
 
Registered: Aug 2007
Location: Massachusetts, USA
Distribution: Solaris 9 & 10, Mac OS X, Ubuntu Server
Posts: 1,189

Rep: Reputation: 105Reputation: 105
What method are you using to do full backups and incremental backups? You are doing this successfully?

There's not that much difference in methodology between incremental and differential. It's just a question of whether you are getting the difference from the last backup of any sort or the difference from the last full backup. So the first incremental you do is both an incremental and a differential.

Referring to the online documentation:

http://www.mysql.org/doc/refman/5.0/en/backup.html

They say: "At the moment you want to make an incremental backup (containing all changes that happened since the last full or incremental backup), you should rotate the binary log by using FLUSH LOGS."

I haven't actually done this myself before, but the description indicates that the log files are basically the transactions that will take the database from the binary full backup through the transactions that occurred up to the time of the incremental. The log files are text sql commands. That said, a differential would just be the accumulation or concatenation of the successive log files or incrementals. There should be absolutely no difference in this instance.

You FLUSH LOGS, copy the log files to where you are keeping your backups, and continue. Then You do that process again. You are just accumulating more transactions. A recovery would require the application of all those transactions. The specific details of log file names, etc. would have to be worked out, but the link above documents all that.

As another alternative, you might want to take a look at the Zmanda Recovery Manager (ZRM) for MySQL. It is open source, and there is a quick start guide to setting it up:

http://www.zmanda.com/quick-mysql-backup.html
 
  


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
Script for Differential Backup ????? ajeetraina Programming 3 08-01-2007 03:46 PM
Need good suggestions for differential backup Micro420 Linux - Software 2 10-30-2006 12:04 AM
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


All times are GMT -5. The time now is 08:52 AM.

Main Menu
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
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration