Hi :) Is it likely to be possible to connect Base directly to the original data? So that instead of getting an export or a dump of the data it can be read dynamically?
I know it is not what the o.p. is asking for but i often wonder. Regards from Tom :) On 15 January 2014 22:03, Alex Thurgood <[email protected]> wrote: > Le 15/01/2014 22:08, Carl Paulsen a écrit : > > Hi Carl, > >> ) ENGINE=MyISAM DEFAULT CHARSET=latin1; > > This is enough to tell us that the data came from a mysql database > originally. MyISAM is the default engine for non-transactional MySQL > databases : > > http://en.wikipedia.org/wiki/MyISAM > > In the sample table you give, the table/field definitions are particular > to mysql, so if you try to run that sql with another db engine, e.g. in > hsqldb via LO Tools > SQL, it will fail because it will not recognise > the field types you're trying to create (e.g. enum, mediumint. > > So, your best bet would be to import that into a mysql server, assuming > you have one to hand and you have some kind of console/terminal access > (localhost / same machine): > > mysql < '/path/to/myfiletoimport.sql' > > optionally with -p if you require authentication for the user that is > connecting to the mysql server : > > mysql -p < '/path/to/myfileimport.sql' > > There are many web sites on the internet that are full of information on > how to set up and import data into a mysql server. > > > Alex > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
