My Oracle Support Banner

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 )
 Transportable tablespace
 MySQL Dump / Pump or INSERT + SELECT *
  MEB using transportable tablespaces (TTS)

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.