Thanks to Spyke for supplying the code; I was able to run some mysql queries to associate everyone’s comments with their member IDs.
UPDATE exp_comments SET author_id = '1' WHERE name = 'Lisa';
Replace 1 with the member ID (which you can get by going to that member’s profile/hovering over their name in the member list). Also replace the name with the name that they posted with on your old site.
Neither spyke nor I are responsible if you hose your databse doing this; so I highly suggest backing up first!
Note, changes will not show up until a full recount is performed.
—LisaJill 02:03, 5 Dec 2004 (EST)
Category:Importing Category:Database