Amfisse

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.

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

@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.

@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.

@claytonjames thanks for the reply
@kaugko, the thing is I don’t have any backup database but i do have all the directories of my site, but i think this won’t work without getting the origianal database, Im new to this whole world of web creating or developing what so ever, so i built by myself so im quite a little understanding how this works but sometimes things may get really bad tension between me and this site. It all begin when i tried to run my bluehost account to host another domain as a Addon domain then i installed a new wordpress to that addon domain so i don’t know how things went wrong with my old one, i tried to open but all that appears on my screen was directories so i looked up the database but it was gone there was no database so i thought the new wordpress installation made overwriting to my old database, but now looks like i have no other option to make another newly installation, but luckly i found my old contents and pages and posts all of them so now all i have to do is to rebuild them, actually i installed a new wordpress and my old theme and plugins so now the only thing to do is to put contents inside the web, but I really do appreciate the time you guys took to reply my post and try to help me I really thank you guys, God bless ya…

and just for the record when i try to open my site its showing a list of my folders in server and under that there is a text saying ”Apache Server at https://www.rahmoorg.com Port 80” so how is that problem to be fixed thanks again…