Did you bring over your location data? The pulldown list is built from the locations in the database.
Would I find this file in PHPMyAdmin or would this be something I could check on the FTP?
It is part of the WordPress database. Typically the wp_store_locator table. You need to export/import that table to move your locations with you.
PhpMyAdmin can help you with this. There are plugins that will do a restore/backup as well.
I imported all my database I thought. I tried to import just that table and received this error:
Error
SQL query:
— — Database: gro1211007500053 — — ——————————————————– — — Table structure for table wp_store_locator — CREATE TABLE wp_store_locator ( sl_id mediumint(8) unsigned NOT NULL auto_increment, sl_store varchar(255) default NULL, sl_address varchar(255) default NULL, sl_address2 varchar(255) default NULL, sl_city varchar(255) default NULL, sl_state varchar(255) default NULL, sl_zip varchar(255) default NULL, sl_country varchar(255) default NULL, sl_latitude varchar(255) default NULL, sl_longitude varchar(255) default NULL, sl_tags mediumtext, sl_description text, sl_email varchar(255) default NULL, sl_url varchar(255) default NULL, sl_hours varchar(255) default NULL, sl_phone varchar(255) default NULL, sl_image varchar(255) default NULL, sl_private varchar(1) default NULL, sl_neat_title varchar(255) default NULL, sl_linked_postid int(11) default NULL, `sl_[…]
MySQL said: Documentation
#1050 – Table ‘wp_store_locator’ already exists
Should I delete the store locator table and then import? What about recent information since the database transfer, will I lose the newly imported information? Is there a way to merge the tables so not to lose any current information? Thanks for any help.
I’m also comparing my two databases and can’t seem to see a difference. I have all my addresses, cities, zips in the current database, the same as the old.
The table cannot exist. Edit the MySQL export file and remove the create database entry, only keep the inserts.
