Gossamer Forum
Home : Products : Others : MySQLMan :

A newbee question!

Quote Reply
A newbee question!
Hello,
I have installed MysqlMAN onto my server and i find it real cool. Thanks again Team @ GT and Alex. Actually the reason for my post was to get more info about importing data from a flat file database. The following is the structure of my text file database.

jackofnone@usa.net|jackofnone
jackofall@usa.net|Jackofall

Can you please tell me what things i have to click in order to import the data properly.
I have made the database and know to select the fields in which i have to import the data.
But i m not sure with the fields below that.

Please help me out

Best Regs
JackofNone

Quote Reply
Re: A newbee question! In reply to
You should probably use the MySQL LOAD command in the SQL monitor.

And set the delimiter to the | character.

Check the FAQ link below, since I've posted a few ways to do it over in the Links SQL Discussion areas over the past months.

PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://postcards.com/FAQ


Quote Reply
Re: A newbee question! In reply to
The program defaults to pipe delimted, so you should be able to accept the defaults just fine.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: A newbee question! In reply to
Actually the Import in MySQLMan is just a front end to MySQL's LOAD DATA command. =)

Cheers,

Alex

--
Gossamer Threads Inc.