WordPress.org

Ready to get started?Download WordPress

Forums

Copy website from local to remote hosting server (13 posts)

  1. Gavin100
    Member
    Posted 2 years ago #

    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

  2. cubecolour
    ɹoʇɐɹǝpoɯ
    Posted 2 years ago #

    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

  3. Gavin100
    Member
    Posted 2 years ago #

    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!

  4. cubecolour
    ɹoʇɐɹǝpoɯ
    Posted 2 years ago #

  5. Gavin100
    Member
    Posted 2 years ago #

    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?

  6. rebsaf3
    Member
    Posted 2 years ago #

    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!

  7. Gavin100
    Member
    Posted 2 years ago #

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

  8. Gavin100
    Member
    Posted 2 years ago #

    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?

  9. saggiatore
    Member
    Posted 2 years ago #

    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!

  10. Gavin100
    Member
    Posted 2 years ago #

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

  11. saggiatore
    Member
    Posted 2 years ago #

    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.

  12. Paal Joachim Romdahl
    Member
    Posted 2 years ago #

    Try the duplicator a free plugin to upload or backup a local or online site.
    http://wordpress.org/extend/plugins/duplicator/

  13. Gavin100
    Member
    Posted 2 years ago #

    Thanks paaljoachim - I'll download and give it a try!

Topic Closed

This topic has been closed to new replies.

About this Topic