[Kexi] Export a Kexi table as mySQL

[martal]

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
> Kexi at kde.org
> 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.