I’ve noticed that my process is rather slow and i’d like to speed it up.
I want to be able to duplicate my database from my domain which is blueharlequin.com and work locally thus speeding up the process. The reason I want to do that is because our website has specific loops that I cannot duplicate without knowing the category ID as well as other things.
I’ve already downloaded wp-db-backup and uploaded the .sql into PHPmyAdmin however everything I click will link me to my website which is not what I want.
My question is how do I make it work locally?
I will suggest WordPress Duplicator, It is best tool for copying your site to any other host/localhost, and its free, I have used it many times and it works every-time with different server settings.
Please note that I haven’t affiliated with it in any way.
You will transfer your db a couple of time from and to your live and dev site, so I would suggest downloading and installing a plugin called Velvet Blues Update URL’s. This will take care of all the rewriting for you.
This is how to use it. Once installed and activated, go to ‘Tools >> Update URL’s. This will open the following screen
In the ‘Old URL’ field, add the address of your livesite. Don’t forget to add the ‘www’ if your site uses it.
In the ‘New URL’ add the address of your test local host. It is usually as indicated below if you are using XAMMP.
You now have to tick all options, and click ‘Update URLs NOW’. When your done, just Update your permalinks again.
EDIT
Sometimes you need to change the site and home urls manually in the db in order to get access to your installation. When you log into your db, click on
wp_options. Line 1 and 36 is the site and home urls respectively. Change that to your url for your installation