On Thu, Aug 20, 2009 at 06:55:25PM +0200, Emanoil Kotsev wrote: > 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
it's not a problem with exporting into sql. it's a problem with importing sql into mysql, because there a subtle differences in table definitions and for some reason importing into mysql didn't work twice. I've managed to get it to work third time around. mk -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org