Where are posts stored?

Started by sgandtg, January 02, 2009, 04:05:04 PM

Previous topic - Next topic

sgandtg

Hi all.

I changed the url of my site and although I've managed to get everything transferred, I want to find all the references to my old url and replace with the new one.  However, there will be 100's if not 1000's of times that the old address will have been typed by a user in the forum.  So I was hoping that there was a way of using something like a find xxx.com [nofollow] and replace with yyy.com [nofollow], but I need to know where the posts are saved on the webspace.

Hope this makes sense.

TIA

Tyrsson

The post are stored in the database.
PM at your own risk, some I answer, if they are interesting, some I ignore.

karlbenson


sgandtg

thanks for that. I've found them.

Which leads me to my next question........

how do I do a search & replace?  lets say my site was www.123.com [nofollow] and the new one is www.456.com [nofollow]

I can see a bit where I can do an sql command, but not sure what to type.

JimM

Jim "JimM" Moore
Former Support Specialist

Advertisement: