How to bulk change the url on the site?

Question

Joomla

Hello. The problem is this. There is a site. One for WP, one for Joomla. There was a need to replace urls from the type site.com to urls like site.com/ru
There are hundreds of pages on the site. Do not do it by hand. Tell me how to do it easier?

Answer 1

in files:

grep -rl 'apples' /dir_to_search_under | xargs sed -i 's/apples/oranges/g'

in base:

UPDATE your_table
  SET your_field = REPLACE(your_field, 'apples', 'oranges')
  WHERE your_field LIKE '%apples%'

If it is expected that they may be in unexpected places in the database, then you can export the database to a .sql file, make a replacement in it, and upload it back.