Jump to content

Archived

This topic is now archived and is closed to further replies.

Mregina

Insert data from a textfile into table

Recommended Posts

SORRY ABOUT THE DOUBLE POST

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.

Share this post


Link to post
Share on other sites
Well, you probably mean LOCAL, if you're giving it a file path... but this is a sever-dependent configuration option.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.