I'm rebuilding a wiki that was previously on 1.5.6. I have a good mysql dump of the database but trying to use that didn't work so well. What I ended up doing was a fresh install on the server with mw 1.18 and exported/imported all the pages. (It's not a big wiki). The problem now is getting user accounts migrated to the new wiki. I've looked at the mysqldump's from both versions and there's some big differences.
I did attempt to run a manual "INSERT INTO blah blah" on the new server using the format I could discern from the dump, and the user account I created was indeed added. But any attempt to login failed. Tried to "email new password" and the wiki said there is no user by that name.
How can I cleanly migrate the user accounts from the old 1.5.6 to the new 1.18? The few references I've seen to extensions that might do this all seem to be out of date so I'm a little wary to attempt them.
On Mon, Dec 12, 2011 at 12:28 PM, Stephen Berg (Contractor) stephen.berg.ctr@nrlssc.navy.mil wrote:
I'm rebuilding a wiki that was previously on 1.5.6. I have a good mysql dump of the database but trying to use that didn't work so well. What I ended up doing was a fresh install on the server with mw 1.18 and exported/imported all the pages. (It's not a big wiki). The problem now is getting user accounts migrated to the new wiki. I've looked at the mysqldump's from both versions and there's some big differences.
I did attempt to run a manual "INSERT INTO blah blah" on the new server using the format I could discern from the dump, and the user account I created was indeed added. But any attempt to login failed. Tried to "email new password" and the wiki said there is no user by that name.
How can I cleanly migrate the user accounts from the old 1.5.6 to the new 1.18? The few references I've seen to extensions that might do this all seem to be out of date so I'm a little wary to attempt them.
After doing a backup of your 1.5.x wiki, you should update the files to 1.18 and then run update.php from the command line.
-Chad
On 12/12/2011 12:02 PM, Chad wrote:
On Mon, Dec 12, 2011 at 12:28 PM, Stephen Berg (Contractor) stephen.berg.ctr@nrlssc.navy.mil wrote:
I'm rebuilding a wiki that was previously on 1.5.6. I have a good mysql dump of the database but trying to use that didn't work so well. What I ended up doing was a fresh install on the server with mw 1.18 and exported/imported all the pages. (It's not a big wiki). The problem now is getting user accounts migrated to the new wiki. I've looked at the mysqldump's from both versions and there's some big differences.
I did attempt to run a manual "INSERT INTO blah blah" on the new server using the format I could discern from the dump, and the user account I created was indeed added. But any attempt to login failed. Tried to "email new password" and the wiki said there is no user by that name.
How can I cleanly migrate the user accounts from the old 1.5.6 to the new 1.18? The few references I've seen to extensions that might do this all seem to be out of date so I'm a little wary to attempt them.
After doing a backup of your 1.5.x wiki, you should update the files to 1.18 and then run update.php from the command line.
Tried that, it broke the wiki. Some pages wouldn't come up at all, just a blank web browser window. That's why I exported all the pages from the old wiki/server to the new wiki/server. My content is fine but the user accounts need to be moved.
On Tue, Dec 13, 2011 at 4:08 AM, Stephen Berg (Contractor) stephen.berg.ctr@nrlssc.navy.mil wrote:
Tried that, it broke the wiki. Some pages wouldn't come up at all, just a blank web browser window. That's why I exported all the pages from the old wiki/server to the new wiki/server. My content is fine but the user accounts need to be moved.
Blank pages tend to suggest a PHP/Apache issue, For some info on how to debug, Have a glance at http://www.mediawiki.org/wiki/Manual:How_to_debug.
Drop the tables created by MediaWiki 1.18 (drop & recreate the db). Import the old database in mysql. Run maintenance/update.php, so that MediaWiki 1.18 updates the db to the latest schema.
You will want $wgMysql5 = false; Beware of http://www.mediawiki.org/wiki/Manual:Backing_up_a_wiki#Latin-1_to_UTF-8_conv... you may need to add --default-character-set=latin1 to the mysqldump command.
mediawiki-l@lists.wikimedia.org