Posted by paul on 07/08/05 07:02

paul wrote:

> I've got phpMyAdmin running for exporting various formats but I just
> don't see how to import data. I want to grab the online info to my local
> setup for testing. We had a tab delimited text file import tool but it
> was somewhat limited especially in regards to related tables, it was
> pulling off a flat excel file.
>
> Sorry this is a mySQL question but I don't see any *active* mySQL groups
> on usenet.


Well, to answer myself (using google (Doh!)):

If you are using phpMyAdmin
1. click Sql
2. click browse
3. browse for the .sql file on your comupter and ok
4. click go

That's OK but it'd be nice not to have to rebuild all the tables and
only add new data too... but my needs are covered for the moment.

[Back to original message]