Changes between Version 8 and Version 9 of SqLiteToMySql

Timestamp:

Sep 4, 2008, 9:20:46 PM (16 years ago)

Author:

anonymous

Comment:

add some stuff (mainly from MySqlDb wiki page) to help users with issues running the sqlite2mysql script

SqLiteToMySql

@@ -72 +72 @@
 http://trac-hacks.org/wiki/SqliteToMySqlScript
 
-This worked really well... painless.
+This worked really well... painless.  The only issues you might run into are with character collation on your database.  With the default latin1 character set and latin1 collation, /path/to/file and /path/to/FILE are identical, potentially causing index collisions.  It is highly advised that you create your database with UTF8 binary collation '''and''' set the server's default table type to InnoDB:
+
+ * in my.cnf:
+{{{
+[mysqld]
+default-table-type = InnoDB
+}}}
+
+ * in the mysql client:
+{{{
+CREATE DATABASE trac DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
+}}}
 
 Also, look at ticket:6986 to significantly improve Trac performance with MySQL.