Support » Localhost Installs » Moving from local to live host on one MySQL Database

  • Resolved hermanthegerman


    I am trying to clone a site that I have been developing locally with MAMP to my live server, but am having trouble getting pages, the sidebar, widgets, images, etc to show up. I am attempting to upload it to one MySQL database by using a different table prefix in the wp_config.php file. The database already has one WordPress install on it, which I previously developed live, so I’m sure this isn’t impossible.

    So far, I have got my child theme to show, and imported page content with WordPress importer, but widget content, sidebar settings, plugins, and the media library do not register.

    I have tried downloading all of the local site tables as a MySQL file, then searching and replacing all instances of the local url with the new hosted url, and uploading the database to my live server, once the new WordPress has been uploaded to it. Unfortunately, this brings up an error message on the first table (I think?); wp_commentmeta. I have also tried creating a blank table in PhpMyadmin, but it I can’t find a way to upload the sql file to it.

    Would really appreciate some help. Most tutorials I find tell you to create a new MySQL database, which I cannot do. Thanks in advance anyone.

Viewing 3 replies - 1 through 3 (of 3 total)
  • edit*- ‘sure this is possible’- I previouslt had another live developed wordpress website installed on the one database as well



    Forum Moderator

    That worked a treat thanks. It wasn’t completely straightforward though.

    For others, if you are backing up your site locally, WP clone creates a backup zip file in your uploads directory. On my live WordPress installation, the ‘restore from URL’ function in WP Clone didn’t work with the local zip file. I had to upload it via FTP to my uploads folder on the live site, then restore from that url for it to work.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Moving from local to live host on one MySQL Database’ is closed to new replies.