Re: Starting to hate MySql... thinking about using MS Sql Server instead...... :-(((((((((

On my ms box at home when I first started with mysql I used mysql> LOAD DATA INFILE "doc.txt" INTO TABLE tablename; instead of mysql> LOAD DATA LOCAL INFILE (etc...) delete 'local' Now I use phpmyadmin at work on my linux box... <M> On Sun, 2003-03-30 at 18:30, Doug Thompson wrote: > There's nothing like RTFM to douse the fire in a rant. > > <quote> > 4.2.3 Startup Options for mysqld Concerning Security > The following mysqld options affect security: > > --local-infile[=(0|1)] > 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 > http://www.webyog.com/ > > hth, > Doug > > > On Sun, 30 Mar 2003 13:46:23 -0700, Sparky Kopetzky wrote: > > >ARGGHHH!!! > > > >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 > > -- Mignon Hunter Web Developer Toshiba International 713.466.0277 x 3461