mysql Workbench. Copy table between DBs.

Can anyone suggest the best way to copy an entire table, including all data, indexes, PKs, FKs etc... from one database to another?

I have two seperate databases on two seperate servers, and need to copy some tables from one to the other.

Thanks in advance.

Jason
Jay1607Asked:
Who is Participating?
 
Cornelia YoderConnect With a Mentor ArtistCommented:
0
 
Jay1607Author Commented:
sorry... I forgot to mention... I'm using mySQL5 Workbench .. loooking for a way to do perform this function in workbench.

Cheers
0
 
arnoldCommented:
FK relate to data in other tables, you would need to clarify what it is you are tying to do.

Could you recheck and clarify your request/question?
0
 
Jay1607Author Commented:
Certainly does.  Thanks!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.