[Marco van Herwaarden]

Originally Posted by borbole

Or you can do it manually by doing the following.

After the user is registered again, go to the phpmyadmin in the cp of your host, select the database name that your forum resides on and at the SQL tab run the following query:

UPDATE post SET userid='newusersid' WHERE username='exusername';

And replace the uid and username accordingly.

Then as last but not least, go to: Admin CP -> Maintenance -> Update Counters and run the Rebuild Thread Information, Rebuild Forum Information, Update User Names, Update Post Counts.

Note, before you run the last option ( Update Post Counts), read the description under the title.

Hope it helps.

Updating posts is not enough. What about threads? PM's? etc..

The only secure way of doing this would really be to restore the database.