Summary

• Page properties (2 modified, 0 added, 0 removed)

Details

Page properties

Author

...	...	@@ -1,1 +1,1 @@
1		-XWiki.BeatBurgener
	1	+XWiki.ThomasMortagne

Content

...	...	@@ -67,7 +67,6 @@
67	67	<property name="connection.username">xwiki</property>
68	68	<property name="connection.password">xwiki</property>
69	69	<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
70		-<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
71	71	<property name="connection.useUnicode">true</property>
72	72	<property name="connection.characterEncoding">UTF-8</property>
73	73	{{/code}}
...	...	@@ -162,6 +162,19 @@
162	162	In case the above script fails to convert some rows with "ERROR 1833 (HY000) at line 1: Cannot change column 'columnname': used in a foreign key constraint 'FK2bj2ghquiq79toomkvugw7iie' of table 'xwiki.tablename', you can drop the foreign keys, convert the columns and then restart xWiki. Hibernate will re-create the dropped indexes automatically.
163	163	)))
164	164
	164	+(% class="box infomessage" %)
	165	+(((
	166	+In case the above script fails with "ERROR 1118 (42000) at line 1: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs
	167	+xwikistatsvisit", you can use the following SQL statements to change tables column types to LONGTEXT to be able to convert the tables to utf8mb4.
	168	+)))
	169	+
	170	+{{code}}
	171	+ALTER TABLE activitystream_events MODIFY ase_url LONGTEXT, MODIFY ase_title LONGTEXT, MODIFY ase_body LONGTEXT, MODIFY ase_param1 LONGTEXT, MODIFY ase_param2 LONGTEXT, MODIFY ase_param3 LONGTEXT, MODIFY ase_param4 LONGTEXT, MODIFY ase_param5 LONGTEXT;
	172	+ALTER TABLE xwikistatsreferer MODIFY XWR_REFERER LONGTEXT;
	173	+ALTER TABLE xwikistatsvisit MODIFY XWV_USER_AGENT LONGTEXT, MODIFY XWV_COOKIE LONGTEXT;
	174	+ALTER TABLE xwikipreferences MODIFY XWP_LEFT_PANELS LONGTEXT, MODIFY XWP_RIGHT_PANELS LONGTEXT, MODIFY XWP_DOCUMENT_BUNDLES LONGTEXT;
	175	+{{/code}}
	176	+
165	165	You can also look at [[this snippet to perform this conversion inside XWiki>>snippets:Extension.Migrate MySQL databases to utf8mb4]].
166	166
167	167	== Convert from MyISAM to InnoDB ==