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

Discuss the database features

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

Postby 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.
Last edited by Ron19855 on Tue Sep 17, 2019 7:04 pm, edited 1 time in total.
OpenOffice 4.1.6 - Windows 7 Ultimate
Ron19855
 
Posts: 5
Joined: Thu Dec 27, 2018 11:25 pm

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

Postby 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)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27108
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby Ron19855 » Tue Sep 17, 2019 7:05 pm

Worked, thank you for the help!
OpenOffice 4.1.6 - Windows 7 Ultimate
Ron19855
 
Posts: 5
Joined: Thu Dec 27, 2018 11:25 pm


Return to Base

Who is online

Users browsing this forum: No registered users and 7 guests