[Kexi] Export a Kexi table as mySQL

[Jarosław Staniek]

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