Advertisement:

Author Topic: Where are posts stored?  (Read 1351 times)

Offline sgandtg

  • Semi-Newbie
  • *
  • Posts: 12
Where are posts stored?
« 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

Offline Joey Smithâ„¢

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 6,356
  • Gender: Male
Re: Where are posts stored?
« Reply #1 on: January 02, 2009, 04:19:29 PM »
The post are stored in the database.

Offline karlbenson

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,629
  • Gender: Male
    • Criminal Brief UK
Re: Where are posts stored?
« Reply #2 on: January 02, 2009, 06:36:51 PM »
smf_messages table

Offline sgandtg

  • Semi-Newbie
  • *
  • Posts: 12
Re: Where are posts stored?
« Reply #3 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 [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.

Offline JimM

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 11,980
  • Gender: Male
    • Southern Spirit Hunters
Re: Where are posts stored?
« Reply #4 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?
Jim "JimM" Moore
Former Support Specialist

Please do not PM me for support!                   
Installing SMF
Upgrade SMF
Manual Installation of Mods