WordPress.org

Forums

Database problems in moving from localhost to live server (5 posts)

  1. Liusan
    Member
    Posted 1 year ago #

    I'm trying to move my site and database from localhost (MAMP) to my live server and am having problems understanding the db:

    1. Created the new WP (3.7) site on localhost using MAMP. All is well on the localhost side.
    2. Exported the db using the localhost phpMyAdmin and imported to the live server using my host's phpMyAdmin.
    3. Problem: my db structure doesn't have any "wp_*" tables at all -- where is "wp_options" so I can change the site URL to the live site?

    Am I missing something really big and obvious here? I've migrated WP sites and db from localhost to live servers in the past, with previous version of WP. Did something change with WP 3.7?

  2. Liusan
    Member
    Posted 1 year ago #

    To give more detail, these are the tables I see:

    columns_priv
    db
    event
    func
    general_log
    help_category
    help_keyword
    help_relation
    help_topic
    host
    ndb_binlog_index
    plugin
    proc
    procs_priv
    proxies_priv
    servers
    slow_log
    tables_priv
    time_zone
    time_zone_leap_second
    time_zone_name
    time_zone_transition
    time_zone_transition_type
    user

    Where are all the wp tables?

  3. manavkumar
    Member
    Posted 1 year ago #

    No there is no changes in WP-3.7 migration process. I think you have exported wrong db structure from your localhost because there are lots of table you have missed in your list (shown above).
    here is the basic WordPress db tables list:

    wp_commentmeta
    wp_comments
    wp_links
    wp_options
    wp_postmeta
    wp_posts
    wp_term_relationships
    wp_term_taxonomy
    wp_terms
    wp_usermeta
    wp_users

  4. 2ninerniner2
    Member
    Posted 1 year ago #

    @Liusan -

    What you exported and imported was the mysql database ... those are the tables for it. This is the db that is part of your local MySQL server installation; nothing to do with any site that may be installed.

    In the left pane in phpMyAdmin, you should have a database named whatever you named it when you set it up locally using MAMP's phpMyAdmin. THAT is the one to export and then import into a new, empty db on the remote site.

  5. Thimothe
    Member
    Posted 1 year ago #

    Hi Liusan,

    I find that the plugin Duplicator is amazing when I want to transfer my site back and forth between live and dev environment. You should give it a try.

    Create a backup of your live server
    Create a copy of your local site using Duplicator
    Upload the installer and backed up copy to your live server
    Run the install
    Configure requested fields
    For security reasons, remove the backup file and installer from your live server
    Tada, magic is done

    I hope this was useful

Topic Closed

This topic has been closed to new replies.

About this Topic