I have MySQL Enterprise full and incremental backups (.FRM and .IBD files).

I have copied the full backup files to a different server, created table structures and imported the data the data using IMPORT TABLESPACE.

How do I import the data from the incremental backup files?

  • Doesn't MEB come with support from Oracle?
    – akuzminsky
    Jun 15 '20 at 22:25
  • Hi Viki, Can you provide more details regarding steps have performed ? It would be help to solve your problem. Jun 16 '20 at 3:33
  • Hello Jyoti, I have a Full backup weekly(Sunday) and Incremental backups every 2 hours. on a test server, i have created new schema (TestSchema), created all the tables, executed DISCARD TABLESPACE, copied the .IBD files and executed IMPORT TABLE SPACE. Everything is working fine. Now i need to move the incremental backup data (.IBD files) to that TestSchema. Please let me know how it can be done.
    – Viki
    Jun 16 '20 at 12:32
  • 1
    That's not the way how MEB works. Try reading this first: dev.mysql.com/doc/mysql-enterprise-backup/3.12/en/… Jun 16 '20 at 19:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.