LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
Reload this Page How to backup a single database using Percona XtraBackup?
User Name
Password
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!

Notices


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

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

Hi

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....

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

Rep: Reputation: 73
Hi,

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

Cheer
 
Old 12-08-2014, 10:16 AM   #3
Dieds
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.
 
  


Reply



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

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 12:54 AM.

Contact Us - Advertising Info - Rules - Privacy - LQ Merchandise - Donations - Contributing Member - LQ Sitemap -
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
Open Source Consulting | Domain Registration