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

    (@numeeja)

    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

    Thread Starter Gavin100

    (@gavin100)

    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

    (@numeeja)

    https://codex.www.ads-software.com/WordPress_Backups

    Thread Starter Gavin100

    (@gavin100)

    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?

    Gavin,

    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!

    Thread Starter Gavin100

    (@gavin100)

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

    Thread Starter Gavin100

    (@gavin100)

    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!

    Thread Starter Gavin100

    (@gavin100)

    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 https://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.
    https://www.ads-software.com/extend/plugins/duplicator/

    Thread Starter Gavin100

    (@gavin100)

    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.