Where are posts stored?

[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.

[karlbenson]

smf_messages table

[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]

What exactly are you wanting to search & replace?

How do I ask support questions the smart way?