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
