LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   How to backup mysql single table with increment (https://www.linuxquestions.org/questions/linux-server-73/how-to-backup-mysql-single-table-with-increment-646347/)

sgm277 06-02-2008 03:55 AM

How to backup mysql single table with increment
 
Hi folks ,

Is there somebody know How to backup mysql single table with increment ?

Wim Sturkenboom 06-02-2008 05:44 AM

An easy way would be something like
Code:

mysqldump youroptions yourdatabase yourtable > yourfile
What do you mean by increment?

sgm277 06-02-2008 08:39 PM

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 :)

trickykid 06-02-2008 10:35 PM

Quote:

Originally Posted by Wim Sturkenboom (Post 3171866)
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.

sgm277 06-03-2008 12:01 AM

I just want to do incremental backup of a single table which is important .I know how to bakcup a database with increment .

Wim Sturkenboom 06-03-2008 12:31 AM

Quote:

Originally Posted by trickykid (Post 3172760)
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.

trickykid 06-03-2008 09:07 AM

Quote:

Originally Posted by sgm277 (Post 3172826)
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.

choogendyk 06-03-2008 07:32 PM

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

trickykid 06-04-2008 11:46 AM

Quote:

Originally Posted by choogendyk (Post 3173883)
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.. ;)

sgm277 06-05-2008 01:16 AM

Thank you all of you !!!


All times are GMT -5. The time now is 03:27 AM.