You will have to consult the Help for the ‘SQL’ database to find out what it needs. The next step is to export it from Calc in a format suitable for the ‘SQL’ database. With the cursor in cell A1, do Edit > Paste. Select File > New and create a Calc spreadsheet. That copies the contents of the table to the clipboard. Select Table, and select the table to export, then select Edit > Copy. The suggested way to export data from Base is to use Calc as a ‘helper’ application. Which brings in native support for Base-MySQL connections. (for Debian/Ubuntu systems and the like) If you are working particularly with MySQL you may find useful to install the package: sudo apt-get install libreoffice-mysql-connector I also think that if you know in advance that you’ll be using your DB with MySQL or other DBMSs this is the best option to take since the creation of the DB. The wizard is quite self-explanatory, so you’re done. When you create a new DB the wizard will show you the possibility to connect your Base file to an existing database (using various protocols). Several parts: SET DATABASE COLLATION "Latin1_General" INSERT INTO "Contatti" VALUES(2,'pluto','pluto') INSERT INTO "Contatti" VALUES(1,'pippo','pippo') INSERT INTO "Contatti" VALUES(0,'prova','prova') Here’s how the result of the command looks like on a test db I have created: SET DATABASE COLLATION "Italian"ĬREATE CACHED TABLE "Contatti"("IDAccount" INTEGER NOT NULL PRIMARY KEY,"NomeAccount" VARCHAR(50),"Descrizione" VARCHAR(250)) ![]() You will find the SQL dump of the database in the file /.sql On Windows this can look like: SCRIPT 'c:/my documents/mydb.sql' Also replace and with your path and filename respectively. Exporting your existing DB to a MySQL DB.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |