Changes between Version 9 and Version 10 of SqLiteToMySql

Timestamp:

Jun 17, 2010, 8:07:47 PM (14 years ago)

Author:

Nacho Larrateguy <lilarrateguy@…>

Comment:

comments to keep in mind before importing data.

SqLiteToMySql

@@ -33 +33 @@
 cat trac.mysql.sql trac.sqlite.sql.dataonly > trac.sql  
     }}}
+----
+One thing to note is that SQLite uses utf8 as default. If you have your server configure with encoding other than utf8 and you can't change that, you are going to get your data bad encoded.
 
+Despite the fact that you may probably already set your MySQL database to user utf8 as a default character set, you could have problems when you import data. It's very important to keep in mind that your connection encoding counts. So be sure that whatever software you use as client you set your charset as utf8. As an example for the console client:
+
+{{{
+mysql trac_db -h host -u user -p --default-character-set=utf8 < trac.sql
+}}}
 ----