Re: copy a table from my MYSQL another engine MYSQL
Posted by:
Rick James
Date: September 02, 2015 03:05PM
Plan A: Write code to connect to both, read from one, write to the other.
Plan B: Use mysqldump to export the table(s) you want, then use mysql to import on the other machine. This approach is reasonably simple and straightforward.
Plan C: If MyISAM, 3 files can be copied. If InnoDB, look into "transportable tablespaces".
Subject
Views
Written By
Posted
1343
September 01, 2015 05:51PM
Re: copy a table from my MYSQL another engine MYSQL
748
September 02, 2015 03:05PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.