LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 06-02-2008, 03:55 AM   #1
sgm277
LQ Newbie
 
Registered: Apr 2008
Posts: 13

Rep: Reputation: 0
How to backup mysql single table with increment


Hi folks ,

Is there somebody know How to backup mysql single table with increment ?
 
Old 06-02-2008, 05:44 AM   #2
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
An easy way would be something like
Code:
mysqldump youroptions yourdatabase yourtable > yourfile
What do you mean by increment?
 
Old 06-02-2008, 08:39 PM   #3
sgm277
LQ Newbie
 
Registered: Apr 2008
Posts: 13

Original Poster
Rep: Reputation: 0
Thank you ,I want to backup a single table with increment like we backup database with increment .I don't know how to do ,do you see me
 
Old 06-02-2008, 10:35 PM   #4
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by Wim Sturkenboom View Post
An easy way would be something like
Code:
mysqldump youroptions yourdatabase yourtable > yourfile
What do you mean by increment?
Incremental backup, when you only backup what's changed from the previous backup. Standard backup terminology.

Honestly the only way you can get an increment with MySQL is if you install or use something like MySQL ZRM from zmanda.com

You have to enable bin logging to achieve this as well which in some cases can be a performance decrease, etc.
 
Old 06-03-2008, 12:01 AM   #5
sgm277
LQ Newbie
 
Registered: Apr 2008
Posts: 13

Original Poster
Rep: Reputation: 0
I just want to do incremental backup of a single table which is important .I know how to bakcup a database with increment .
 
Old 06-03-2008, 12:31 AM   #6
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
Quote:
Originally Posted by trickykid View Post
Incremental backup, when you only backup what's changed from the previous backup. Standard backup terminology.
Thanks for clarifying; I could not link increment to incremental. I thought OP wanted a sequence number or something like that in the filename.
 
Old 06-03-2008, 09:07 AM   #7
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by sgm277 View Post
I just want to do incremental backup of a single table which is important .I know how to bakcup a database with increment .
Well, like I said, there really is no easy way. Either install MySQL ZRM which can do this or come up with some fancy scripting that grabs the data from the bin logs associated for that table. I don't know of anything else out there that can really do this. There's hotbackup from the InnoDB guys but it costs money.
 
Old 06-03-2008, 07:32 PM   #8
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
ZRM for MySQL is highly configurable. You can specify a particular table to backup if that is all you want -- http://mysqlbackup.zmanda.com/index.php/Mysql-zrm
 
Old 06-04-2008, 11:46 AM   #9
trickykid
Guru
 
Registered: Jan 2001
Posts: 24,133

Rep: Reputation: 199Reputation: 199
Quote:
Originally Posted by choogendyk View Post
ZRM for MySQL is highly configurable. You can specify a particular table to backup if that is all you want -- http://mysqlbackup.zmanda.com/index.php/Mysql-zrm
Yeah, I already mentioned it twice already..
 
Old 06-05-2008, 01:16 AM   #10
sgm277
LQ Newbie
 
Registered: Apr 2008
Posts: 13

Original Poster
Rep: Reputation: 0
Thank you all of you !!!
 
  


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
shell script/command for converting columns/table onto a single line skuz_ball Programming 9 11-30-2007 03:02 AM
backup-manager doesn't increment pjo Ubuntu 2 01-21-2007 06:16 AM
MYSQL DROP TABLE not working after restoring from backup. leongoogs Linux - Software 0 06-17-2004 07:16 PM
MySQL non-realtime table-by-table mirroring Passive Linux - Software 1 01-20-2004 12:11 PM
How to import MS ACCESS Table including OLE filed into the MySQL Table ? myunicom Linux - General 1 11-28-2003 11:30 AM


All times are GMT -5. The time now is 01:49 PM.

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