Thread:Project:Support desk/Codepage utf8 problems ?/reply (3)

I found that the problem really was related to a corruption of my NameSpaces combined with some import problems. The nameSpaces was corrupted on my MW 1.12 release, and it appears that MW 1.18.1 now contains more tables.... so you should definitely 'not' drop the tables at any time (?).

I guess I did drop the database/tables/contents, "too much", as I thought the Import would

This is the way I "upgraded" from 1.12 to the 1.18.1 latest release, on my local ISS/MySql:


 * Dump the old tables, using MySql Workbench, and check off the blob dump export marker - use the self-contained version, to get all in a singel file.


 * Make an clean install of MediaWiki 1.18.1, but STOP after download of the localsetting.php file
 * Probably, use the same sysop user as in the original database, also use the same name for the database
 * Cut paste any special nameSpace modifications you made from your original localsetting.php, to the new one (remove any other special setup for extensions etc., these need to be revised and installed again)
 * Start up the new MediaWiki, but do not make any changes yet!
 * To check if the nameSpaces was correct you can make a fake search for any word, and the nameSpaces should appear there
 * Edit the .sql export file, to change the database name, if you did not use the same as before
 * Use MySql Workbench to import the .sql exported dataset
 * Finally run the >PHP update.php command from the \maintenance directory
 * I guess that some problems can/could have been solved using 'php rebuildall' (That was not possible for me on the original installation, as I was not sure if the backup would work at all, so I'm a chicken! :-)
 * I guess that some problems can/could have been solved using 'php rebuildall' (That was not possible for me on the original installation, as I was not sure if the backup would work at all, so I'm a chicken! :-)

Start up your Wiki (refresh main page?), and things should be working!

Now you can add any extensions and other special changes you made in original localsetting.php?

Please, if you get similar problems this may help you - let me know if this works for you, I guess that there can be other database related problems as well.

My conclusion is that I will in the future have to mirror my Wiki installation on my local machine, just to be 100% sure that I have a full working backup. Especially that is needed when playing with stuff that may corrupt the tables/indexes. (Say, Having a mirror installation would enable me to simulate an update, run the update.php locally.