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.