On my ms box at home when I first started with mysql I used
mysql> LOAD DATA INFILE "doc.txt" INTO TABLE tablename;
mysql> LOAD DATA LOCAL INFILE (etc...)
Now I use phpmyadmin at work on my linux box...
On Sun, 2003-03-30 at 18:30, Doug Thompson wrote:
> There's nothing like RTFM to douse the fire in a rant.
> 4.2.3 Startup Options for mysqld Concerning Security
> The following mysqld options affect security:
> If one uses --local-infile=0 then one can't use LOAD DATA LOCAL INFILE.
> <end quote>
> This setting has been defaulted to 0 in recent releases. You can read more than you
> probably want to here:
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> PHHPmyadmin is a good gui, but I prefer sqlyog which you'll find at
> On Sun, 30 Mar 2003 13:46:23 -0700, Sparky Kopetzky wrote:
> >Trying to use INFILE to load a small (125) entry block of data and all MqSql does
> >is puke:
> >ERROR 1148: The used command is not allowed with this MySql version. (3.23.55)
> >If this command is no good, then what the hell am I supposed to use????
> >At least with MS, you have a nice, GUI to use...
> >Robin Kopetzky
> >Black Mesa Computers/ISP
713.466.0277 x 3461
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php