Moved to localhost xampp from livehost but there is a bit problem

Did you do this?

You will have the change the 2 fields in the wp_options table in the database to the new “location” (generally https://localhost/wp-install-foldername/)

– option_id # 3 = siteurl
– option_id # 39 = home

Cheers!
Lyle

Hi Amfisse
I just found your post here. I was wondering could you send me a link to the tutorial you used as I want to do the exact same thing as you but I’m have big problems. All I get when I try to launch the site on localhost is ‘error trying to connmect to database’ message. Please send me that link if you can as I think the reply you have from 2ninerniner2 will work.

Thanks

Hi Hi Amfisse
Forgive my spelling in that last post, I was rushing and didn’t check it.

@geroido, Hi no worries mate, here is the tutorial link https://www.youtube.com/watch?v=b7z4uzfcyNQ
this dude seems he is doing pretty fast some of the fellas didn’t get but if you ever feel this is to much or fast you can watch other tutorials which is vice-verse in other words How to move wordpress from localhost to liveserver, all the process is the same moving a site from localhost or livehost so i have another tutorial which i think is pretty clear to understand and you can try to do the opposite way and copy your livehost to localhost and i recommend this one because i tried the first one and i thought that was pretty old and didnt get how to do so i tried to watch the other tutorials which is moving wordpress from localhost to liveserver and i tried to do the opposite way from Livehost to localhost, and it did work for me pretty cool, I tried to move my 2 websites from live to local and they all working fine but i’m still having a problem one of them while the other one is working just like when it was on the liveserver but this is not the case how i moved. https://www.youtube.com/watch?v=sknV3mB-lRc watch this one too.

@2ninerniner2
Hi , thanks for your reply, i tried to find the 2 fields you mentioned but the thing is my wp_options table contains only 30 tables so i have no option id 39- home or something else, but the siteurl seems pretty fine i can see the link to my localhost site so please can you explain a little more further if you can, I moved another website along this one im having problem with but the other one is fine and all its working fine posts, links, pages they all working nothing had happened to the other one but this one the home page seems everything is there posts, pages, links but if i try to navigate or open a link or post or page there is when it gets dirty please explain a little more where else can i change these things, Thanks alot.

Hi Amfisse
Thank you for that reply. I’ll give that a go later and see what I get. Did you need to alter any username, password details in the config files of the xampp install. Xampp installs with default ‘root’ username and blank password for mysql. Did this cause a conflict with the live site database username and password details?
Again thanks for the lengthy reply. Incidentally, I was just thinking, does the “No worries mate” in your reply make you an Aussie? I remember that from my years in London when I met so many Australians. Just an afterthought!!!

Hi again geroido, well I have a couple instructions you to follow if you feel a little bit unsure how to do it and it’s a pretty fast way and i did this way and it worked well, here is it

Firt open your website’s cpanel and go to phpmyadmin and export the database of the site you are thinking to move, save it to the desktop or whereever you want, then you do need to do this things below

1. Open the SQL database you exported from your liveserver with Wordpad or any other editor you have.

2. Go edit and click the replace or CTRL+H and type the ‘Find what’ field https://www.yoursite.com or https://yoursite.com depends which url your are using your website is it www. or without it when your opening it. type ”Replace with” field this https://localhost/yoursite and then hit Replace it all then save that file, this process is altering all links directing to your livehost into localhost, some people don’t really want to do this so they prefer to go their dashboard and settings and change their url there but later when they moved their site to locally they no longer access to their livesite so they need to change it again in phpmyadmin which is a pretty long process.

3. Go to your xampp phpmyadmin and create a new database with username and so on and be sure that you note your database information you will need it when you are goin to edit wp-config.php file later, this happend so many times that i forget the user and database name and the password so be sure to note it down the information you put there.

4. Click your database on the left panel in your phpmyadmin and import your SQL database that you edited before and hit GO.

5. This step you need to copy all your site files using FTP in your cpanel or Filezilla, the easiest way is to put all your files into one folder in your Computers Desktop so you can easily move to xampp later and change folders name to yoursite name in localhost for example ‘yoursite’.

6. When it finish coping your files from server then move your ‘mysite’ folder into xampp/htdocs put in there htdocs folder in your xampp and then open your folder and edit your wp-config.php so now you need your information you note it down when you created the new database in your xampp and change the wp-comfig.php and put the database name and username and the password u chosen before and then save it.

so now open your web browser and hit localhost/yoursite and everything should be working now.

sorry for the long post now it feels like you are a in a History class or something else which is sometimes boring hahah, I’m not really profissional doing this so you can figure it out my post which is a really long one but i feel we can help each other, Well I’m from Australia as u suspect it no one ever thought that Im from there while reading my posts but u did.

Hope you can make it and let me know if this works for you please.

Good Luck

Sorry again if u feel exhausted reading this but u dont need to fellow them all u might allready done but as u asked before Yes u need to change your wp-config.php with your localhost database information.