Jump to content

I deleted all the countries in Countries & Zones. Now I want to restore the previous state. What do I need to do?


Recommended Posts

Go to admin, Maintenance, Database tab. Scroll to the table CubeCart_geo_country. Make note that there are zero records.

Obtain the following file from a stock download of CubeCart and load it into a text editor: /setup/db/install/data.sql

Then, in admin, Maintenance, Query Database (Advanced), take note of the Query box. You will be pasting a lot of lines in here.

From the file, starting at about line 507, there will be 243 lines (all the way to the bottom of the file, don't miss getting all of the last line) that needs be copied to the system's clipboard, then pasted into the Query box. Then click Go.

Note: I haven't actually done this, so, be prepared if this does not go as desired. The only table being affected is CubeCart_geo_country which holds all the country names.

 

Edited by bsmither
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...