Convert Trac DB, from SQLite to MySQL

This is a copy from the mailing list …

% echo ".dump" | sqlite trac.db > trac.sql
% mysql tracdb < trac.sql

There could be syntax errors that would have to be manually fixed in the file trac.sql.

1. Use trac-admin initenv to create the database structure
2. Use mysqldump —no-data to dump the database structure into trac.mysql.sql
3. Use sqlite .dump to dump the structure + data from sqlite into trac.sqlite.sql (unfortunately there's no option to only dump the data).
4. Remove all the structure ('create table' and 'create index') from trac.sqlite.sql
5. Concatenate trac.mysql.sql and trac.sqlite.sql into trac.sql