Changes between Version 6 and Version 7 of SqLiteToMySql
- Timestamp:
- Sep 30, 2007, 6:26:01 AM (17 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SqLiteToMySql
v6 v7 50 50 sys.stdout.write(file) 51 51 52 $ cat trac.sqlite.sql | ./cleansql.py> trac.sqlite.sql.dataonly52 $ ./cleansql.py < trac.sqlite.sql > trac.sqlite.sql.dataonly 53 53 }}} 54 ---- 55 One gotcha for all this is that the reports stored in the report table might not work as expected. I solved this by: 56 1. Dropping the report table from my newly migrated trac mysql db 57 2. Dumping the report table from the temporary trac mysql db I created to get the schema(in steps 1 and 2 at the top of the page) 58 3. Loading the sql dump back in to my newly migrated trac mysql db 54 59 55 this doesn't work 60 One catch is that this will only restore the default trac queries. If you had custom queries you will still need to re-write them if they don't work right on MySQL. 61 62 {{{ 63 mysql -D tracmysql -e "drop table report" 64 mysqldump -D temptracdbforschema report > report.sql 65 mysql -D tracmysql < report.sql 66 }}} 67 You need to get the full report table from the mysql db you created for its schema in to your new mysql trac db. This also assumes that you did not have any custom queries and were just using the defaults.