RE: [PHP] phpmyadmin

I believe you need the FILE privledge to do this. If you're not root, chances are you can't do this. You might try using the 'mysqlimport' utility. It will import mysql dumps. Jason > -----Original Message----- > From: jeremy brand [mailto:jeremy@nirvani.net] > Sent: Wednesday, December 13, 2000 6:03 PM > To: Jerry Lake > Cc: php-general@lists.php.net > Subject: Re: [PHP] phpmyadmin > > > MySQL will. You need to define your schema first, then do a simple: > LOAD DATA INFILE '/tmp/thefile.txt' into table table_name; > > Works like a charm every time. > > Jeremy Brand :: Sr. Software Engineer :: 408-245-9058 :: > jeremy@nirvani.net > http://www.JeremyBrand.com/Jeremy/Brand/Jeremy_Brand.html for > more > Get your own Free, Private email at http://www.smackdown.com/ > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > At least for the people who send me mail about a new language that > they're designing, the general advice is: do it to learn about > how to write a compiler. --Dennis Ritchie > > On Wed, 13 Dec 2000, Jerry Lake wrote: > > > Date: Wed, 13 Dec 2000 16:56:54 -0800 > > From: Jerry Lake <jerryl@europa.com> > > To: php-general@lists.php.net > > Subject: [PHP] phpmyadmin > > > > will phpmyadmin directly import a CSV file? > > > > Jerry Lake > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > _______________________________________________________ Site Design, Hosting, and E-Commerce at www.webpipe.net