Thanks Jaroslaw. I will try this. But I have to reinstall a Linux first!. Will let the forum know on how it worked.
Jarosław Staniek wrote: > > martal said the following, On 2007-05-11 16:14: >> I finally got my 3500 row table from MS Access into Kexi. >> >> Now I want to export it as mySQL, so I can work on it in both XP and >> Ubuntu, >> with PHP. >> >> Any ideas on how to go about that? > > Hello, > This direction is not supported by now. You can try to export using > intermediate .sql dump. > > 1. From command line: > > ksqlite yourdb.kexi .dump > yourdb.sql > > 2. (optional) Then, you may want to alter datatypes in the CREATE TABLE > commands of the .sql file, e.g. if you need some fine-tuning. > > 3. The last step is to import the stuff: > > mysql -u username -ppassword database_name yourdb.sql > > > See also http://www.sqlite.org/cvstrac/wiki?p=ConverterTools > > -- > regards / pozdrawiam, Jaroslaw Staniek > Sponsored by OpenOffice Polska (http://www.openoffice.com.pl/en) to work > on > Kexi & KOffice: http://www.kexi.pl/en, http://www.koffice.org > KDE3 & KDE4 Libraries for MS Windows: http://kdelibs.com, > http://www.kde.org > _______________________________________________ > Kexi mailing list > [email protected] > https://mail.kde.org/mailman/listinfo/kexi > > -- View this message in context: http://www.nabble.com/Export-a-Kexi-table-as-mySQL-tf3727686.html#a10767973 Sent from the Kexi General mailing list archive at Nabble.com. _______________________________________________ Kexi mailing list [email protected] https://mail.kde.org/mailman/listinfo/kexi
