wordpress-search-replace

SQL script used to search and replace URLs in a wordpress project in the migration process

How to run

• make database backup!
• run phpmyadmin and select database
• copy code from SQL script search-replace.sql
• paste it to phpmyadmin SQL tab
• find two variables at the bottom of the script and replace them with your url's

SET @FIND_URL = 'http://localhost/projects-name/';
SET @REPLACE_URL_WITH = 'https://www.example.com/';

• run script (at your own risk)