Jump to content


Insert data from a textfile into table

  • Please log in to reply
1 reply to this topic

#1 Mregina

  • New Members
  • Pip
  • Newbie
  • 4 posts

Posted 08 September 2006 - 08:00 PM


hey all.

i'm having a problem here. i'm trying to upload a table into the database. i've tried .csv, excel, .txt, word... and none work. if i select DATA as my upload method i get the following error:
#1045 - Access denied for user: 'clearpo_master@localhost' (Using password: YES)

and if i use DATA LOCAL i get:
#1148 - The used command is not allowed with this MySQL version

so im confused. ive tried it every which way except the right way apparently. im running phpMyAdmin 2.5.3 with MySQL 4.0.24.

if anyone could give me a tip, i'd appreciate it.

#2 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 08 September 2006 - 08:01 PM

Well, you probably mean LOCAL, if you're giving it a file path... but this is a sever-dependent configuration option.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users