If you were moving your wordpress database from an old domain to new one and have completed transferring files and database to new hosting account, you might need a search and replace php script that will remove all the links to old domain from your database and replace them with the new one.
The very first step is to download this script from https://interconnectit.com/products/search-and-replace-for-wordpress-databases/ and save it to your desktop. You may rename this script to whatever you want.
Additionally, you will be needing a ftp program like filezilla or some other one to upload this file to the root of your wordpress installation.
Run search and replace mysql script
Type in the name of the search and replace script that you just uploaded to your website’s root as shown in the screenshot with your domain name.
For example: http://www.yourdomainname.com/searchreplacedb.php in your browser to run this script.
When you hit submit, it will auto detect all the necessary information required in the next step.
Click Submit DB details to proceed to next step.
Press continue and move to next step. Make sure you have all the tables selected.
Now, at this stage you can enter your old url on the first field followed by the new one just below it on the other field and press submit search string. It will take few seconds depending upon the size of your database and return a sql query of the operation performed.
No comments yet.