How do I re-install countries?

[offie]

Hi, I want to re-install countries in the drop down tab during creating an account. I used my sql to delete all country entries apart from UK. I now realise that should a customer want to buy anything from another part of Europe etc then they can not only create an account but if I use paypal pro etc then they will also not be allowed to proceed from the payments page.

 

So what is the best way to re-install all the countries in the database? Thanks for any help.

 

Michael

[BryceJr]

Hi, I want to re-install countries in the drop down tab during creating an account. I used my sql to delete all country entries apart from UK. I now realise that should a customer want to buy anything from another part of Europe etc then they can not only create an account but if I use paypal pro etc then they will also not be allowed to proceed from the payments page.

 

So what is the best way to re-install all the countries in the database? Thanks for any help.

 

Michael

Inside oscommerce.sql, which can be found inside the oscommerce install folder, are the insert statements to put countries back. Copy and paste the insert statements you want back similar to running sql queries.

[offie]

Inside oscommerce.sql, which can be found inside the oscommerce install folder, are the insert statements to put countries back. Copy and paste the insert statements you want back similar to running sql queries.

 

Thanks for the info and I have found the folder with the items but which parts do I need to use and how do I do it? I have found all the code for the countries entry such as:

 

INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1');INSERT INTO countries VALUES (2,'Albania','AL','ALB','1');

 

all the way to:

 

INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1');

 

Now do I just copy all those entries and then run a query with them on mysql or do I insert them somewhere myself?

 

What about all the code at the top of the oscommerce.sql. There are varies comments like:

 

# $Id: oscommerce.sql 1818 2008-01-15 09:10:52Z hpdl $
#
# osCommerce, Open Source E-Commerce 

#
# NOTE: * Please make any modifications to this file by hand!
#   

* DO NOT use a mysqldump created file for new changes!
#	   * Please take note of the table structure, and use this
#		 structure as a standard for future modifications!
#	

  * Any tables you add here should be added in admin/backup.php
#		 and in catalog/install/includes/functions/database.php
#	   * To see the 'diff'erence between MySQL databases, use
#		 the mysqldiff perl script located in the extras
#		 

directory of the 'catalog' module.
#	   * Comments should be like these, full line comments.
#		 (don't use inline comments)

DROP TABLE IF EXISTS address_book; etc etc etc

 

Do any of these comments affect my ability to copy and paste these country entries?

 

Thanks, Michael

[offie]

Thanks for the info and I have found the folder with the items but which parts do I need to use and how do I do it? I have found all the code for the countries entry such as:

 

INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1');INSERT INTO countries VALUES (2,'Albania','AL','ALB','1');

 

all the way to:

 

INSERT INTO countries VALUES (239,'Zimbabwe','ZW','ZWE','1');

 

Now do I just copy all those entries and then run a query with them on mysql or do I insert them somewhere myself?

 

etc etc

 

Its OK, I have done it.

 

Backed up my database first then tried running an sql query just using those country values and it worked. Thanks for your help, Michael

[BryceJr]

;) ;)