XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / How do I "find & replace" in database??
Register
1
carnuke
How do I "find & replace" in database??

  • 2004/4/9 20:05

  • carnuke

  • Home away from home

  • Posts: 1955

  • Since: 2003/11/5


I've just moved my site to another server and need to change an URL that occurs several times in the database. How can I do this using MySQL admin?

Thanks all

Richard
2
Mithrandir
Re: How do I "find & replace" in database??

UPDATE table SET field='www.new-url.com" WHERE field='www.old-url.com'
3
carnuke
Re: How do I "find & replace" in database??

  • 2004/4/9 20:18

  • carnuke

  • Home away from home

  • Posts: 1955

  • Since: 2003/11/5


Thanks Mithrandir... saw you come online and hoped you would catch this question Will this allow me to change only the domain?

Richard

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

340 user(s) are online (46 user(s) are browsing Support Forums)

Members: 0

Guests: 340

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Oct 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits