Mysql command needed - 05/09/2003 9:10 AM
Hello everyone!
I need help with a mysql command to convert PMs. We are running an older version of threads, 6.1.1 IIRC. I want to change an admin's name in the mysql database, but want him to have his pm's and what not saved. Is there a script out there or series of mysql commands that I can submit manually, to "convert" from the old username to the new username?
The most important one to have available is PMs. That is the bare minimun, but it would be nice to be able to search posts by the new username instead of the old.
Thanks, and if you need further info, don't hesitate to ask, I'm usually on AOL IM as "p74vic".
Thanks!
Jason
I need help with a mysql command to convert PMs. We are running an older version of threads, 6.1.1 IIRC. I want to change an admin's name in the mysql database, but want him to have his pm's and what not saved. Is there a script out there or series of mysql commands that I can submit manually, to "convert" from the old username to the new username?
The most important one to have available is PMs. That is the bare minimun, but it would be nice to be able to search posts by the new username instead of the old.
Thanks, and if you need further info, don't hesitate to ask, I'm usually on AOL IM as "p74vic".
Thanks!
Jason