Request Tracker sqlite to mysql migration

Question

I'm planning to migrate request tracket 3.6 from present server. The rt is running on sqlite and the new one will be mysql. Is there any way to migrate sqlitedb to mysql server.

Thanks in Advance.

Answer 1

I have no experience with request tracker.

In debian there's the package sqlite3-doc. In the file /usr/share/doc/sqlite3-doc/sqlite.html look at the commands .dump and .schema to export the sqlite database tables.

In mysql you can import these SQL files similarly.

If request tracker already created the database and tables, you need not to export the schema.