Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 22 Jun 2014, 10:39
dutchbb dutchbb is offline
 
Join Date: Dec 2003
This will work right?

UPDATE thread
SET title = REPLACE(title, '++++','****')

UPDATE post
SET pagetext = REPLACE(pagetext, '++++','****')


Obviously I want to replace the f-word shown as ++++ here, in the database with asterisks, just wanted to have the query checked to be sure.

Additional question: can I do this without overloading the page for manual queries in ACP? It's an 8 million post database on an owned server with only this one forum running.

Last edited by dutchbb; 22 Jun 2014 at 10:50.
Reply With Quote
  #2  
Old 22 Jun 2014, 11:16
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
That should work yes, but you should always make a backup before doing a risky UPDATE statement.

It's hard to say if the server gets overloaded, it kind of depends on the server specifications and the configuration of the MySQL server.
Reply With Quote
  #3  
Old 22 Jun 2014, 11:19
dutchbb dutchbb is offline
 
Join Date: Dec 2003
Ok tried it, titles work, posts takes too long (504 error). I've got the backup. Thanks Dave
Reply With Quote
  #4  
Old 22 Jun 2014, 11:22
Dave Dave is online now
 
Join Date: Jun 2010
Real name: Dave
Originally Posted by dutchbb View Post
Ok tried it, titles work, posts takes too long (504 error). I've got the backup. Thanks Dave
In case you're on a VPS or dedicated server, login into mysqladmin on the server and execute i t there. That way you will not face a timeout.
Reply With Quote
  #5  
Old 22 Jun 2014, 12:52
dutchbb dutchbb is offline
 
Join Date: Dec 2003
Yes works, tnx again
Reply With Quote
  #6  
Old 22 Jun 2014, 15:39
webmastersun's Avatar
webmastersun webmastersun is offline
 
Join Date: Oct 2013
you can make your forum broken by changing like that
__________________
The best webmaster forum & internet marketing forum for webmasters and internet marketers.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:21.

Layout Options | Width: Wide Color: