MySQL Forums
Forum List  »  Newbie

How to export table from db01 and import it into db02 ?
Posted by: Fran Lee
Date: March 05, 2018 03:30PM

I have a database named db01 with tables table01 and table02

I dump db01 and end up with two files...

db01_table01.sql

db01_table02.sql

Before I import them into db02 can I just delete the db01_ so the file names end up named...

table01.sql and table02.sql and then do the import...

or should I rename them to db02_table02.sql and db02_table02.sql

or what?

I'm unsure if the database name db01 underbar at the beginning of the exported tables is important.

Thanks for any help.

Options: ReplyQuote


Subject
Written By
Posted
How to export table from db01 and import it into db02 ?
March 05, 2018 03:30PM


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.