Re: how to migrate request-tracker database from sqlite3 to mysql

[Emanoil Kotsev <deloptes@yahoo.com>]

Martin Kraus wrote:

> 
> hi. I'm trying to migrate request-tracker3.6 database from sqlite to mysql
> on
> lenny.  Is there a way to export data from sqlite so they can be imported
> into mysql for request-tracker3.6?
> 
> rt-dump-database doesn't export sqlite database and sqlite and mysql
> databases for rt are not compatible even if I dump sqlite database into
> sql and modify the file it can be imported into mysql.
> 
> thanks for any tips
> martin

there is actually a nice php interface to sqlite which can do the export in
sql. I'm not sure if you can import into mzsql, but I think there is such
an option in phpmyadmin

regards