Methods Available to Copy A Table(s) Or Schema
(Doc ID 2508418.1)
Last updated on MARCH 03, 2020
Applies to:MySQL Server - Version 5.6 and later
Information in this document applies to any platform.
To take a copy of a working data-set, eg for use in a QA / DEV environment.
In a scenario where it is desired to take a copy of a working data-set for any reason, often the best approach is to use / restore a recent backup of the database.
Depending on requirements for the copy ( consistent vs inconsistent ) or the load on the DB ( users / concurrent access ) or simply the size potentially being prohibitivly large, there are a number of options available.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|Complete copy and restore ( interim DB )|
|MySQL Dump / Pump or INSERT + SELECT *|
|MEB using transportable tablespaces (TTS)|