How can i import sql?

[rainbowlook]

Hi all, i am new to MySql.

 

Iv just downloaded the MultiGeoZone Multi Table Module. And in its readme file.

The step 2 for installation is :

 

Import SQL file `_install_sql/INSTALL_v1.000.sql` to your DB.

 

How can i import it to my db?

[Guest]

Use PHPMyAdmin (ask your host where it is) and run teh sql query on the database. make sure you back it up first.

 

TJ

 

Hi all, i am new to MySql.

 

Iv just downloaded the MultiGeoZone Multi Table Module. And in its readme file.

The step 2 for installation is :

 

Import SQL file `_install_sql/INSTALL_v1.000.sql` to your DB.

 

How can i import it to my db?

<{POST_SNAPBACK}>

[rainbowlook]

Use PHPMyAdmin (ask your host where it is) and run teh sql query on the database. make sure you back it up first.

 

TJ

<{POST_SNAPBACK}>

 

im in the phpmyadmin now. how can i import it?

[rainbowlook]

thank you for your help!!

 

but sorry that i m compeletely new to database.

 

but im getting better.

 

should i insert that by following the words in the file?

 

the file is INSTALL_v1.000.sql.

 

and inside it is:

 

INSERT INTO configuration_group VALUES ('', 'MultiGeoZone MultiTable Shipping', 'The options which configure the MultiGeoZone MultiTable Shipping Module', '1', '1');

 

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

 

INSERT INTO configuration VALUES ('', 'Number of Geo Zones', 'MODULE_SHIPPING_MZMT_NUMBER_GEOZONES', '3', 'The number of shipping geo zones.', last_insert_id(), '0', NULL, now(), NULL, NULL),

('', 'Number of Tables per Geo Zone', 'MODULE_SHIPPING_MZMT_NUMBER_TABLES', '3', 'The number of shipping tables per geo zone.', last_insert_id(), '0', NULL, now(), NULL, NULL);

[Guest]

Find the SQL tab and find the file using the browse button. then hit GO.

 

Make sure you back up the database first.

 

Search the internet for phpMyAdmin for beginners. :)

 

 

 

 

im in the phpmyadmin now. how can i import it?

<{POST_SNAPBACK}>

[Guest]

INSERT INTO configuration_group VALUES ('', 'MultiGeoZone MultiTable Shipping', 'The
options which configure the MultiGeoZone MultiTable Shipping Module', '1', '1');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE
configuration_group_id = last_insert_id();

INSERT INTO configuration VALUES ('', 'Number of Geo Zones',
'MODULE_SHIPPING_MZMT_NUMBER_GEOZONES', '3', 'The number of shipping geo zones.',
last_insert_id(), '0', NULL, now(), NULL, NULL),
                                ('', 'Number of Tables per Geo Zone',
'MODULE_SHIPPING_MZMT_NUMBER_TABLES', '3', 'The
number of shipping tables per geo zone.',
last_insert_id(), '0', NULL, now(), NULL, NULL);

 

 

Paste this into the query box and hit go :)

 

 

 

 

 

Find the SQL  tab and find the file using the browse button. then hit GO.

 

Make sure you back up the database first.

 

Search the internet for phpMyAdmin  for beginners.  :)

<{POST_SNAPBACK}>

[rainbowlook]

omg!!! omg!!!!!omg!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

ive done it!!!!!!!!!!!!!!!!!!!!!!!!

 

you are great !!!!!!!!!!!!!!!

 

thank a lot!!!!!!!!!!!!

[Guest]

omg!!! omg!!!!!omg!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

ive done it!!!!!!!!!!!!!!!!!!!!!!!!

 

you are great !!!!!!!!!!!!!!!

 

thank a lot!!!!!!!!!!!!

<{POST_SNAPBACK}>

 

 

You are easy to please :)

 

Congratulations on your first query!

:blink: :blink: :blink: :blink: :blink:

[rainbowlook]

You are easy to please  :)

 

Congratulations on your first query!   

:blink:  :blink:  :blink:  :blink:  :blink:

<{POST_SNAPBACK}>

 

 

:D

 

could you help me on another problem. my site is nearly done . :D

 

http://www.oscommerce.com/forums/index.php?showtopic=125741