How to back up and restore a single Library by innobackupex in Mysql

This article will explain in detail how to back up and restore a single library of innobackupex in Mysql. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

How to back up a single library:

Using the-include option

[root@simlinux ~] # innobackupex--apply-log--export / data/databak

It is equivalent to restoring the ibd file.

[root@simlinux ~] # ll / data/databak/se

-rw-r--r--1rootroot33829 monthly 1313:57searchaccount.cfg

-rw-r--r--1rootroot163849 monthly 1313:57searchaccount.exp

-rw-rw----1rootroot239689 monthly 1313:40searchaccount.frm

-rw-rw----1rootroot20971529 monthly 1313:40searchaccount.ibd

Copy ibd and other files, and then discard,import. Each table needs to be created, and discard then import.

This method of using innobackupex backup to restore a single library is quite cumbersome.

On the Mysql innobackupex how to backup and restore a single library to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.