Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 12-06-2014, 10:04 AM   #1
Registered: Feb 2007
Posts: 210

Rep: Reputation: 16
Question How to backup a single database using Percona XtraBackup?


How can i backup only one database from mysql and restore it back using Percona Xtrabackup tool?

I am on Centos 6.6 64Bit and i have a db 40GB Innodb tables....

I know how to do it for a full Mysql backup but i prefer to have a solution to backup/restore only my database and not any other mysql folders/files....

Old 12-07-2014, 05:46 PM   #2
Registered: Aug 2010
Location: Netherlands
Distribution: Kubuntu, Debian, Suse, Slackware
Posts: 317

Rep: Reputation: 73

use the mysql dump command to dump the tables you're interrested in and backup those dump files.

Old 12-08-2014, 10:16 AM   #3
LQ Newbie
Registered: Sep 2013
Distribution: Percona Server
Posts: 1

Rep: Reputation: Disabled
Hi, I'm Percona's community manager. There is a post scheduled for tomorrow (Dec. 9) that will address this issue on Percona's MySQL Performance Blog. I'll try to remember to come back and post it here but just in case go to Percona's website tomorrow and it should be the top post.


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
Set password for single database of phpmyadmin fortran Linux - Server 2 03-19-2012 05:18 AM
[SOLVED] How to backup all mysql database individually in single command sanjay87 Linux - Server 6 03-17-2012 01:19 PM
Newbie trying to write a simple backup script to backup a single folder Nd for school stryker759a Linux - Newbie 2 09-16-2009 08:52 AM
how to create backup MYSQL Script to backup my database for every 1hour RMLinux Linux - Newbie 3 11-20-2008 10:13 AM
How to Umount single MySQL database KimVette Linux - Software 2 07-13-2005 12:55 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 01:53 AM.

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