Print Page - Where are posts stored?

Title: Where are posts stored?
Post by: sgandtg on January 02, 2009, 04:05:04 PM

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 and replace with yyy.com, but I need to know where the posts are saved on the webspace.

Hope this makes sense.

TIA

Title: Re: Where are posts stored?
Post by: Tyrsson on January 02, 2009, 04:19:29 PM

The post are stored in the database.

Title: Re: Where are posts stored?
Post by: karlbenson on January 02, 2009, 06:36:51 PM

smf_messages table

Title: Re: Where are posts stored?
Post by: sgandtg on January 02, 2009, 07:34:33 PM

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 and the new one is www.456.com

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

Title: Re: Where are posts stored?
Post by: JimM on January 02, 2009, 09:36:13 PM

What exactly are you wanting to search & replace?

How do I ask support questions the smart way? (http://docs.simplemachines.org/index.php?topic=494)

Simple Machines Community Forum

SMF Support => SMF 1.1.x Support => Topic started by: sgandtg on January 02, 2009, 04:05:04 PM