Fixing Absolute Url's - Moving wordpress from live to development

hi this is Tim from cctv design I just want to give you a quick run through how I moved a live website back to a development website because I want to do some major changes that I cant do online never worked with development sight before I had some trouble finding the details so i will take you through how I did it First open my website i'm using phpMyAdmin to look at the website contents and all we've got to do here is go to the export tab don't change anything just click the go button and what will happen is will end up with a export copy of that file which i'm using chome to auto download into my downloads so here is my downloaded files it comes up as a SQL extension and I'm opening it using Notepad plus the link to notepad plus is in the links at the bottom the next step from inside notepad plus is we want to find all instances of my main sites URL which would be http://cctvdesign.com.au so what i want to do and here is a simple find and replace so we go for that one and type in http://cctvdesign.com.au http://cctvdesign.com.au http://cctvdesign.com.au replace that with http://localhost/cctvdesign http://localhost/cctvdesign http://localhost/cctvdesign http://localhost/cctvdesign http://localhost/cctvdesign so we do a replace all what that will is os go through and find all the instances which is probably a few thousand uh... and replaced them with what we needed. there we have twenty four thousand replaced Now save that as a copy of you don't have to put just to show you whats going on here from their will move over to our new database. Import it using phpMyAdmin I've opened up local host copy of phpMyAdmin i'm going to be using that creating a new database We'll call it cctv design I'll create passwords and users for this offline so I've created my user and go in to the database which has no tables so we now want to import the file that we created before now i have no problem here where my file is quite large 84MB I believe and you can't physically import that size what i need to do here is add a modification to the phpMyAdmin soI'll bring that up I found this tutorial that tells you how to get around the restrictions and I'll put the link into the notes below basically will get this error if we try to upload it the normal way so we need to go through into our folder so i'm using WAMP modify the config.inf.php file which I have opend in notepad Plus scroll down to find the area that told us to look for upload directory. So we just name a directory. I've called called up upload and save the file and all we do is place our SQL file into this folder so if i go into my upload folder so i have to create a folder here in phpMyAdmin call it upload copy my SQL file into there and i think refresh this it should come up we now have this dropdown I can select my file from there down the bottom we click go don't change anything else it will do it's processes which can take several minutes and then will be ready to open the website in the localhost server so there we are okay now because of a typing mistake it took me a little time to get it going we've got it to a point that using netbeans WAMP we can run the the website and that will pop up and here we have more website running on a local host hopefully completely functional Not Quite With a little bit of work I will have that working so few seconds further on what the problem was was I had renamed the plugins file so we are just naming that back and once that's done everything will be open working