Forums / Built-in Shipping and Payment Modules / How to get all the countries back? (I deleted them!)

How to get all the countries back? (I deleted them!)

Locked

Results 1 to 3 of 3

This thread is locked. New replies are disabled.

23 Nov 2009, 3:14 AM

ruriimasu

New Zenner

Join Date:: Apr 2009
Posts:: 14
Plugin Contributions:: 0

How to get all the countries back? (I deleted them!)

Hi all,
I removed all the countries from the shipping address except one. Now I would like to get back the other countries. How do I go about getting them back without manually typing the countries one by one? Is there a particular page with the information that I can re-upload? Appreciate your help in advance :hug:

23 Nov 2009, 3:19 AM

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 177

Re: How to get all the countries back? (I deleted them!)

In the Zen Cart original files zip, there is a /zc_install/sql/mysql_zencart.sql file.
Inside that file are several lines that begin like this:

INSERT INTO countries ...

So, the answer to your question is this:

Go to Admin->Tools->Install SQL Patch
Type in: ```
TRUNCATE TABLE countries;


3. Copy the list of INSERT INTO countries statements from the mysql_zencart.sql file to your computer's clipboard, and PASTE that into the SQL Patch window, and click Send.
Done.

23 Nov 2009, 3:58 AM

ruriimasu

New Zenner

Join Date:: Apr 2009
Posts:: 14
Plugin Contributions:: 0

Re: How to get all the countries back? (I deleted them!)

it worked! thanks a lot! :clap: