MySQL Control Center - load from file

[Halfcan]

HI.
Using MySQL Control Center beta 0.9.3,

Does anyone know how to load data from a text file,
and what is required of the txt file?

I've tried tab delimited, and comma delimited, but everything just goes into 1 field.

The HELP contents do not exist, and

http://www.mysql.com

has no manual.

Thanks,
HC

 

[sleipnir214]

MySQL does so have an online manual. It's located here:

http://www.mysql.com/doc/en/index.html

. The entire manual is also searchable.

LOAD DATA INFILE, for example, is documented here:

http://www.mysql.com/doc/en/LOAD_DATA.html

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Halfcan]

Thanks, sleipnir, unfortunately I looking for a manual on "Control Center". You see, I'm dumb and do not know sql syntax. I was looking for help with GUI program.
I guess I will try to figure out how to do this by command line....

Thanks,

HC

 

[sleipnir214]

You can use MySQLCC as your database client. But with it you are likely going to have to create the SQL by hand anyway.

There is a gotcha using a LOAD DATA query. There are two forms of the query: LOAD DATA INFILE and LOAD DATA LOCAL INFILE. The first expects the datafile to be on the server's filesystem, the second expects the datafile to be transferred to the server through your client connection. However, by default MySQL doesn't allow data transmissions through the client connection. I recommend that if at all possible you copy the datafile to the filesystem of the server and use LOAD DATA INFILE.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[Halfcan]

Thanks, again. Guess it's time to start learning sql.
HC