Re: [xwiki-users] Upgrade to 3.2 minor issues

Hi Sergiu, I have updated my database engine to 'InnoDB'. I just took the query from previously attached file and by using Notepad++ and text replace created a set of alters to update engine. I ran those alters one-by-one. With a success :) ============================================== Some helpful queries and steps ============================================== 1. Backup current wiki mysqldump --user=xwiki --password=xwiki --default-character-set=utf8 xwiki_utf8 > dump.sql 2. Create new database CREATE DATABASE db_name xwiki_utf8_innodb CHARACTER SET=utf8 COLLATE=utf8_general_ci 3. Import data from backup into new database mysql --user=xwiki --password=xwiki --default-character-set=utf8 xwiki_utf8_innodb < dump.sql 4. Log-in to mysql mysql --user=xwiki --password=xwiki 5. Switch to newly created database use xwiki_utf8_innodb; 6. Get list of tables requiring update SELECT TABLE_SCHEMA, TABLE_NAME, ENGINE, COLLATION_NAME, CHARACTER_SET_NAME FROM information_schema.`TABLES` T, information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = "xwiki_utf8_innodb"; 7. Capture the output from previous and replace '| xwiki_utf8_innodb |' -> 'ALTER TABLE' '| MyISAM | utf8_general_ci | utf8 |' -> 'ENGINE=InnoDB' 8. Run list of created alters from previous step one-by-one 9. Verify that all engines are updated. 10. Update your hibernate.cfg.xml to use new database 11. Restart Tomcat -- View this message in context: http://xwiki.475771.n2.nabble.com/Upgrade-to-3-2-minor-issues-tp6883965p696… Sent from the XWiki- Users mailing list archive at Nabble.com.