Version 2 (modified by 17 years ago) ( diff ) | ,
---|
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.
- Use trac-admin initenv to create the database structure
- Use mysqldump —no-data to dump the database structure into trac.mysql.sql
- Use sqlite .dump to dump the structure + data from sqlite into trac.sqlite.sql (unfortunately there's no option to only dump the data).
- Remove all the structure ('create table' and 'create index') from trac.sqlite.sql
You could use this simple perl script:
$ cat cleansql #!/usr/bin/env perl while (<>) { $i = $i . $_; } $i =~ s/^CREATE.*?\);$//smgi; print $i; # NEOF $ ./cleansql trac.sqlite.sql > trac.sqlite.sql.dataonly
- Concatenate trac.mysql.sql and trac.sqlite.sql.dataonly into trac.sql
cat trac.mysql.sql trac.sqlite.sql.dataonly > trac.sql
Note:
See TracWiki
for help on using the wiki.