Page 1 of 1

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

PostPosted: Fri Sep 13, 2019 9:55 pm
by Ron19855
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.

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

PostPosted: Sat Sep 14, 2019 12:25 am
by Villeroy
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)

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

PostPosted: Tue Sep 17, 2019 7:05 pm
by Ron19855
Worked, thank you for the help!