Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#13 2012-11-16 01:37:31

mrdale
Member
From: Walla Walla
Registered: 2004-11-19
Posts: 2,215
Website

Re: Find & Replace article text common method/faves

bici wrote: thanks. I have a need to do something along these lines. Where / How does one execute the code?

You need to do it in a mySQL utility like phpmyAdmin (web utility) or Sequel Pro (great mac app) or on the command line.

Offline

#14 2012-11-16 07:30:14

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 4,137
GitHub

Re: Find & Replace article text common method/faves

mrdale wrote:

You need to do it in a mySQL utility like phpmyAdmin (web utility) or Sequel Pro (great mac app) or on the command line.

This. +1 for SequelPro. Beware: MySQL commands like this are instantly activated and can’t be undone easily — there’s no ‘undo’ option, so make a copy of your database before you do stuff to it.

Edit: well, there is an undo option, but it involved writing a SQL command to re-write everything that you changed, and that might not be easy. Backup is recommended. If you can test it on a non-live site, localhost maybe, you’ll at least get an idea of what it looks like without the potential for breaking everything.

Last edited by gaekwad (2012-11-16 08:32:24)

Offline

Board footer

Powered by FluxBB