myPHPadmin, query?

[Jason@fernandes]

I'm a newb at databases and PHP so excuse my newbiness! lol

 

I'm going to upgrade an OS site from version 2.2 rc1 to rc2a. I opened up the upgrade.html file and it says to make these changes to the SQL:

 

alter table banners add index idx_banners_group (banners_group);

alter table banners_history add index idx_banners_history_banners_id (banners_id);

alter table currencies add index idx_currencies_code (code);

alter table customers add index idx_customers_email_address (customers_email_address);

alter table customers_basket add index idx_customers_basket_customers_id (customers_id);

alter table customers_basket_attributes add index idx_customers_basket_att_customers_id (customers_id);

alter table orders add index idx_orders_customers_id (customers_id);

alter table orders_products add index idx_orders_products_orders_id (orders_id);

alter table orders_products add index idx_orders_products_products_id (products_id);

alter table orders_status_history add index idx_orders_status_history_orders_id (orders_id);

alter table orders_products_attributes add index idx_orders_products_att_orders_id (orders_id);

alter table orders_products_download add index idx_orders_products_download_orders_id (orders_id);

alter table products add index idx_products_model (products_model);

alter table products_attributes add index idx_products_attributes_products_id (products_id);

alter table reviews add index idx_reviews_products_id (products_id);

alter table reviews add index idx_reviews_customers_id (customers_id);

alter table specials add index idx_specials_products_id (products_id);

alter table zones add index idx_zones_to_geo_zones_country_id (zone_country_id);

alter table orders_status add public_flag int DEFAULT '1';

alter table orders_status add downloads_flag int DEFAULT '0';

alter table orders modify payment_method varchar(255) NOT NULL;

alter table whos_online modify last_page_url text NOT NULL;

 

Ok so I've never played with myPHPadmin. Are each one of these lines "alter table banners add index idx_banners_group (banners_group); " a query string??

 

If so do I select the "banners" table and click on the SQL tab? From there do I add the SQL query "alter table banners add index idx_banners_group (banners_group); " and select go??

I'm stumped on how to make the changes to the SQL. I did backup the SQL database just in case.

 

Many thanks in advanced

[FIMBLE]

Back up yes.

Make a text file of the update code, call it what you like

in phpmyadmin you will see an insert tab at the top, click it then click browse, then navigate to the folder with the code in.

Click ok

at the bottom of the PHPMYADMIN page click go.

That will do it all for you

Regards

Nic

[Jason@fernandes]

Many thanks Nic, that sounds easy enough. :D

[Jason@fernandes]

Wait, Should i make a txt file for each code?? or can i make one txt file with all the update codes??

[Jason@fernandes]

Back up yes.

Make a text file of the update code, call it what you like

in phpmyadmin you will see an insert tab at the top, click it then click browse, then navigate to the folder with the code in.

Click ok

at the bottom of the PHPMYADMIN page click go.

That will do it all for you

Regards

Nic

 

I clicked on the insert tab and i don't see a browse button, i only see the browse button in the upper right.

You didn't happen to mean the import tab??

[♥geoffreywalton]

1) Go to your ISPs admin area for your site.

 

2) Click on the icon for Mysql, then find the link for phpmyadmin, it might be hidden away at the bottom but not on all admin sites. If you can’t find this, please consult your ISP's help desk.

 

3) In some cases, you may have to choose which database your OSC tables are located on. If this is the case, please choose using the dropdown box.

 

4) Click on "SQL" on the navigation bar.

 

5) Enter/paste your SQL in the textbox provided or, if you have a file containing the sql commands, click on Import and follow the on screen prompts.

 

6) For both methods click "Go"..

 

7) If all goes well, your SQL query will run successfully

 

For another explanation see:-

 

http://www.oscommerce.com/forums/index.php?sho...dmin+mysql+code

 

Or for a contribution to allow you to run SQL Script from Admin

 

http://www.oscommerce.com/community/contributions,4567

 

Cheers!