mysql will not let me load a local file - Linux Forums

Register|FAQ|Member List|Calendar|Unanswered Posts|Forum Rules|Today's Posts|Advanced Search |

Welcome to Linux Forums! With a comprehensive Linux Forum, information on various types of Linux software and many Linux Reviews articles, we have all the knowledge you need a click away, or accessible via our knowledgeable members.

Write an article for LinuxForums Today! Win Great Prizes!

New to Linux Forums? Register here for free!

		Linux Forums > GNU Linux Zone > Servers > mysql will not let me load a local file

Servers Anything server related, Apache, MySQL, Samba, server security, sendmail, exim, etc

Site Navigation
Linux Articles
Linux Forums
Linux Downloads
Linux Hosting
Free Magazines
Job Board
IRC Chat
RSS Feeds

Linux Forum Topics
Linux Forums
Linux Forums Site News
Your Distro
Redhat / Fedora Linux Help Ubuntu Help SuSE Linux Help Mandriva Linux Help Slackware Linux Help Debian Linux Help Gentoo Linux Help Knoppix Help Forum Other Distributions
Linux Resources
Linux Tutorials, HOWTO's & Reference Material
GNU Linux Zone
Wireless Internet Linux Newbie Installation Misc Linux Applications Servers Linux Networking Peripherals / Hardware Linux Desktop / X-Windows Linux Programming & Scripting Gaming / Games / Multimedia / Entertainment Linux Security The Linux Kernel Linux On Laptops / Netbooks / Minibooks Wine Art & Imaging in Linux
The Community
The Coffee Lounge Comments / Feedback / Suggestions Everything BSD

Reply

12-24-2003	#1 (permalink)
bignester Linux User Join Date: Apr 2003 Location: TEXAS Posts: 314	mysql will not let me load a local file ever time i execute this command Code: LOAD DATA LOCAL INFILE "pet.txt" INTO TABLE pet; i get an error that says that this command is not supported with my version of mysql. I've tried starting my database with this parameter Code: mysqld_safe --local-infile=1 I would like to use this feature because the database I'm making will be quite large. __________________ The computer made me do it!! Slackware and SUSE too Gig\'em WHOOOOP!! \"God put me on this earth to accomplish a certain amount of tasks, At the rate I\'m going I will never die.\" (I don\'t know)

12-24-2003	#2 (permalink)
jasonlambert Linux Guru Join Date: Apr 2003 Location: London, UK Posts: 3,284	which version of mysql are you running? alternativly you can copy the file to the server, and use "Load Data infile "filename"" etc etc

12-24-2003	#3 (permalink)
bignester Linux User Join Date: Apr 2003 Location: TEXAS Posts: 314	OK thats was what I was doing wrong. That was what I waws trying to do but I didn't relize that I was trying to upload a local file to the computer I was on rather than the server. __________________ The computer made me do it!! Slackware and SUSE too Gig\'em WHOOOOP!! \"God put me on this earth to accomplish a certain amount of tasks, At the rate I\'m going I will never die.\" (I don\'t know)

Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are Off Pingbacks are Off Refbacks are Off

Free Magazines

Run Your Own Web Server Using Linux & Apache - Free 191 Page Preview
Learn about everything you'll need to build and maintain your Linux servers, and to deploy Web applications to them.
subscribe

Open Source Security Myths Dispelled
Dispel the five major myths surrounding Open Source Security and gain the tools necessary to make a truly informed decision for your IT organization
subscribe

InformationWeek
InformationWeek is the only newsweekly you'll need to stay on top of the latest developments in information technology.
subscribe

All times are GMT. The time now is 05:31 PM.