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.