This is a discussion on sql contribution files and phpMyAdmin within the osCommerce 2.2 Modification Help forums, part of the osCommerce 2.2 Forums category; OK, I've downloaded some contributions that don't come with any instructions - only sql files. (I'm talking about UK_all_zones-1.0 which ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| OK, I've downloaded some contributions that don't come with any instructions - only sql files. (I'm talking about UK_all_zones-1.0 which has the file uk_zones.sql). So, assuming that I need to somehow get this into my database through phpMyAdmin I first open phpMyAdmin. Problem is from WHERE exactly do I Run this sql query (or Browse the Location of the textfile)? First I select my Catalog database and select the SQL - I seem to be able to do it there, but since this is a ZONES file I wonder if I should select the table 'zones' (Database catalog - Table zones running on localhost) then select the SQL tab and run it from there??? Also, I having problems 'Browsing' the location of the sql textiles. Can I open this sql textfile in bbedit and copy and paste it into the field which says 'Run SQL query/queries on database catalog' ??? Is this normal practice? |
| Sponsored Links | ||
| ||
|
#2
| |||
| |||
| You pretty much have it. The only thing, select the database, then copy from bbedit then paste into your sql query/queries then the sql will insert into the correct tables, if there are any errors it will tell you. You dont need to select zones or any other table. This is normal practice for me. and I manage over 50 databases
__________________ There\'s something about fireman, day and night they are always fireman! |
| Sponsored Links | ||
| ||
| Thread Tools | |
| |
| ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Orders and Customers through PHPMyAdmin- not in Admin | kenlyle | osCMax v2 Features Discussion | 0 | 11-06-2006 09:32 AM |
| files under ssl | mrocket | osCommerce 2.2 Installation Help | 2 | 04-28-2006 01:30 PM |
| Oscommerce installation/phpmyadmin | tailormadepc | osCommerce 2.2 Installation Help | 3 | 10-07-2004 06:30 PM |
| How do I edit these files? | Anonymous | osCMax v1.7 Discussion | 2 | 08-03-2004 02:18 PM |
| exporting osC database using phpMyAdmin | Rodland | osCommerce 2.2 Installation Help | 1 | 04-10-2003 10:58 AM |