Take the 2-minute tour ×
WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. It's 100% free, no registration required.

I am trying to migrate my blog from my local web server to an online web server and I have a doubt about this procedure.

I have uploaded all my local file in the root of my web server.

I have also export the tables of my local database (using phpMyAdmin) and I have import them on my online database.

Then I have change the settings inside the file wp-config.php in such a way as to make the connection with the online database.

Now I have to change the URL settings on my database using the Search and Replace Tool script: http://interconnectit.com/products/search-and-replace-for-wordpress-databases/

So my doubts related to the use of the search and replace script are:

1) Have I to put the searchreplacedb2.php file into the root of my webserver (where it is the wp-config.php file) and have I to execute this script?

2) Have I to scann ALL the tables or only the posts table?

Tnx

Andrea

share|improve this question
    
Have you solved the issue or still need a help? –  sven May 23 '13 at 13:50
add comment

2 Answers

What you need to do is simple. Place the file in the root of the website. Access this file via web browser. For example. type - www.yoursite.com/searchreplacedb2.php

In the page, enter your database details, including username and password. Also, specify your localhost http address, which in most cases is localhost

For example, in my testing server, my development files are usually in subfolders, so my link in local host is, localhost/site-1/

Likewise, enter your localmachine server url (localhost) and enter the new domain name there, i.e. yoursite.com

Select all the tables.

and press go. thats it...

share|improve this answer
    
mmm but where have I to put and use the searchreplacedb2.php script file? On my local web server or on my online web server? –  AndreaNobili Apr 2 '13 at 15:04
    
Hi, @AndreaNobili you can either put it in the local server or on your online web server. I would recommend to use it online, since you could continue development on your local site without interrupting any settings or altering your database. Anyways, its your call... :D... Oh, BTW, dont forget to delete that script from your server once you are done with it. Simply delete it using FTP or through the file manager in Cpanel. –  Nithin Omanakuttan Apr 2 '13 at 15:49
add comment

You may want to give my WP Migrate DB plugin a try. It exports your database and does all the find & replaces you need at the same time. Then you jump into phpMyAdmin to import it.

I recently released a pro version that allows you to push or pull the database from your WordPress dashboard. No phpMyAdmin needed. Big time saver.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.