I've changed to a secure server which means that I have loads of posts which have the http:// prefix but need to be https:// prefix. i would like to search and replace in the Mysql database but can't work out where the content of each blog post or forum post is stored. Can anyone help? Thanks.
Where are Blogs and Forum posts Stored in Mysql
Collapse
X
-
Tags: None
-
Hi,
I found this page https://www.guiguan.net/pure-sql-app...ysql-database/
Following the instructions I was able to search and replace all instances throughout the database. Problem solved.
Regards👍 1 -
Following up on the above do NOT use this method. the above code went through all tables and changed all instances of http:// to https:// and broke my database. This was, I believe, that some of the URL's changed related to other sources which should not have been changed.
What I did was the following. I ran this SQL Query at the root level of the database. i.e. my database was called Server: localhost:3306 ยปDatabase: wwwleisu_vbulletin5
In this database I selected the SQL Box and posted the following into it.
UPDATE text SET rawtext = replace(rawtext, 'http://', 'https://');
I then clicked on GO
and all instances of http:// were changed to https://
but only in the Table where most of the content (words) of the Forum Board or Blog threads are stored
The above code will work on any Tables where you want something replaced.
Just change the Table you want to work on from text to whatever and change the Column in that Table from rawtext to whatever.
Always back up your database BEFORE you start.Last edited by robinantill; Sun 25 Oct '15, 3:45am.Comment
Related Topics
Collapse
-
by robinantillI've worked out that there is content is stored in database/text/rawtext as I need to find and replace some content on my board. However there appears to be some posts not in that table.
Can anyone...-
Channel: Support Issues & Questions
Sat 24 Oct '15, 6:11am -
-
Hi,
I'm quite new to vBulletin and need to amend the timestamps of a few posts I've added, that were originally made by members on a previous forum platform - so I need to back date the posts....-
Channel: Support Issues & Questions
Fri 24 Jul '15, 12:57am -
Comment