[Solved] Copy a table from an embedded db to MySQL?

Ron19855 · Post by **Ron19855** » Fri Sep 13, 2019 9:55 pm

Hello, I have my main db running in MySQL and using Base as a front-end. I have a large table in another Base doc that's embedded that I want to move to my non-embedded db. I have tried simply copy and pasting the table over in Base, I get "SQL Status 42000, Error code: 1049, Unknown database. If anyone has any other ideas or advice, it would be greatly appreciated.

Thanks.

edit this topic's initial post · Post by **Villeroy** » Sat Sep 14, 2019 12:25 am

Copy the table icon from the hsqldb.
Paste to the table section of the document which is connected to MySQL.
A wizard pops up ... (more or less self explaining)

Ron19855 · Post by **Ron19855** » Tue Sep 17, 2019 7:05 pm

Worked, thank you for the help!

[Solved] Copy a table from an embedded db to MySQL?

[Solved] Copy a table from an embedded db to MySQL?

Re: Copy a table from an embedded db to MySQL?

Re: Copy a table from an embedded db to MySQL?