Support » Localhost Installs » Copy website from local to remote hosting server

  • Hi … new to all of this! Developed a website on my local PC and now need to move it to a hosted server. There are sooo many different documents related to the topic that it is difficult to follow which is relevant. I created a DB on the remote server, used Filezilla to ftp all my files to public_html and then edited the config.php to reflect my ‘new’ DB info. Logged into the remote site and duly ran the install …. My website doesn’t appear – only the newly installed empty WP site. Also, my original DB doesn’t seem to have copied across ……….

    Please help ! Many thanks

Viewing 12 replies - 1 through 12 (of 12 total)
  • Moderator cubecolour


    You need to export the database and import it into the new database.

    Also the database will have references to the local server URL, so you will need to do a search & replace on the backup to change every instance to the new URL. A good way of doing this is to use the. Interconnect/it serialized search & replace tool

    Hi cubecolour … thanks for the speedy reply!

    How do I export the database and import it into my new DB?
    Also, when you say I need to search and replace on the backup, do you mean the DB backup?

    As I said, toally new to this …

    Thanks again!

    Moderator cubecolour


    Thanks – read that and downloaded and installed MYSQL administrator – did a backup of my DB (!) and using then, using my host server’s cpanel, imported the tables into my newly created DB. I now have my tables installed on the hosting server, but still only see the newly installed worpress site (the sample page, etc – not my pages)- what am i missing and where do I change it?


    On your locally installed database go to the dashboard => Tools => Export.

    Export Everything.

    Then on your new webserver, go to dashboard => Tools => Import and import the xml file that you exported from your local machine.

    That will do the trick!

    Hi Rebsaf3 – thanks! Will try it shortly and let you know.

    That worked! Many Thanks!!
    Another problem I have…. my import into the new db didn’t work – My old DB is called ‘wordpress’ and my new db (for the import) is called ‘training’ – when attempting to import the .sql file, it says access denied to the current user for db ‘wordpress’
    How do I get the ‘wordpress’ tables into my ‘training’ db?

    This may not have to do with this forum post. But I am trying to copy from remote to local. Have been testing on my server, but want to work on the site when offline. I moved all the files and modified the wp-options table to point to localhost/mysitefolder. The site works fine but I can’t login via wp-admin for some reason. I get a server error. Anyone experienced this? I’ve looked through all the forums and haven’t found anything that works!

    Hi saggiatore, what was the server error? Did you change config.php as well?

    Hey Gavin100,
    It sais: “The website encountered an error while retrieving http://localhost/rocksaucechocolate/wp-admin/. It may be down for maintenance or configured incorrectly.” rocksaucechoclate obviously being my client. I have modified the database, the functions file in the theme directory. I did change the config.php file as well. Nothing seems to work. I’m baffled.

    Try the duplicator a free plugin to upload or backup a local or online site.

    Thanks paaljoachim – I’ll download and give it a try!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Copy website from local to remote hosting server’ is closed to new replies.