Database problems in moving from localhost to live server
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?
To give more detail, these are the tables I see:
Where are all the wp tables?
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:
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.
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
- The topic ‘Database problems in moving from localhost to live server’ is closed to new replies.