sql contribution files and phpMyAdmin

[Rodland]

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?

[|3ackdraft]

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