LOAD DATA [LOW_PRIORITY] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE]
INTO TABLE tbl_name
[FIELDS
[TERMINATED BY '\t']
[OPTIONALLY] ENCLOSED BY '']
[ESCAPED BY '\\' ]]
[LINES TERMINATED BY '\n']
[IGNORE number LINES]
[(col_name,...)]
The LOAD DATA
The "%" in the first command to User table spoils it all. It means logging from ffrom
any host is valid .
Remove that command. It'll work
Cheers
Donald
- Original Message -
From: David Hulka
To: [EMAIL PROTECTED]
Sent: Monday, February 26, 2001 1:28 AM
Subject: Setting
Hello All !!!
I 'm in a rather strange position . I've a servlet that fetches data from a MySql DB .
If the database is without a password it works perfectly fine . Ironically if i assign
a user name and passwd to the DB the servlet doessn't seem to like it and throws up
the foll :
Some guys here lurk around only to get their problems solved and chuck off the
minute any kindred list memeber solves it . For them it just feels so smart thinking
that the list is the best place to get their work done without paying a dime .
So all u guys intending to only take and not
Hello
The hosting company has given me a user name and passwd . When i log into my own site
thro' a telnet session i 'm able to view all the databases created in the server that
includes DBs not created by me . I also did a "USE DB" command to connect to a DB
that wasn't mine . Also
Start the deamon First
shellmysqld-XXX
To find out what X means go to the bin directory below and find out . d
stands for daemon
then key
shellmysql
Cheers
Donald
- Original Message -
From: "soon chee keong" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, February 06,
Hello !!
I'm trying to upload my database that's build locally on Win ME machine to a remote
Linux server . I'm using Ace-Ftp to upload my normal files. But i couldn't seem to
find the data files to which i can upload my database thro' Ace-Ftp . I've heard that
uploading the database needs to