Changes between Version 29 and Version 30 of MySqlDb

Timestamp:

Feb 25, 2009, 2:07:12 PM (15 years ago)

Author:

anatoly techtonik <techtonik@…>

Comment:

+ hints how to convert database

MySqlDb

@@ -93 +93 @@
 == Conversion ==
 
+==== MyISAM to InnoDB ====
+
+For every table in Trac database issue:
+{{{
+ALTER TABLE `table_name` ENGINE = InnoDB;
+}}}
+
+==== Collation from "whatever" to "utf8_bin" ====
+First modify DB collation:
+{{{
+ALTER DATABASE `trac_database` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
+}}}
+
+Then modify tables - issue the following for every table:
+{{{
+ALTER TABLE `table_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
+}}}
+
+==== From SQLite ====
 While a more robust method may be created for [milestone:0.10.4] to allow easy conversion from SQLite to MySQL, users have reported success with the [wiki:SqLiteToMySql following method].