#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Riverside, CA 92507
    Posts
    2
    Rep Power
    0
    I have a database of at 2,000 records that I need to load into my database table in MySql. I'm using the following command and getting the following error.

    LOAD DATA INFILE '/home/mywww/dealer.txt' INTO TABLE dealerlist;


    ERROR 1045 at line 1: Access denied for user: 'teac26@localhost' (Using password: YES)

    From what I can tell this is my ISP blocking access because of security issues. I've talked to my host and they offer a file input solution. to do this, I will have to go into my text file and input individual commends in front of every record and field. this is not a time saving solution for 2,000 records.

    Does anyone know a way around this? Please keep in mind, i am a complete newcomer to MySQL and need as detailed an explanation as possible. Thanks in advance for your expert advice!
  2. #2
  3. No Profile Picture
    Carpe Diem
    Guest
    Devshed Newbie (0 - 499 posts)
    Hi

    I would be happy to look at the file and see if I can make the changes for you.

    It might be a simple matter of writting a small perl program to do the job.

    Just e-mail me

    Regards
    Darren http://www.php4hosting.com/
  4. #3
  5. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,642
    Rep Power
    4492
    Are you trying to copy a database from one location, to another? or is that all you have is a comma-delimited text file from another source?

    Usually if you don't have 'file' access, it'll tell you when it says access denied. If i try alter, i'll get something like alter command not allowed. i would think it's the same for files.

    Can you write a PHP script (or perl) that will read the file and do inserts for each line?

    or, like my first question said, is this just moving a database from one place to another? if so, look at mysqldump. dump the first database into a text file of SQL statements. then just run

    mysql -uuser -p your_database < your_file

    Hope that helps...email me if you have a question, i don't wander onto the msyql forum to much...

    ---JH
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2000
    Posts
    1
    Rep Power
    0
    Try this...

    LOAD DATA LOCAL INFILE '/home/mywww/dealer.txt'
    INTO TABLE dealerlist;

    Curt

Similar Threads

  1. load data infile PHP parse error
    By georgeatef in forum PHP Development
    Replies: 3
    Last Post: June 8th, 2004, 11:07 PM
  2. Newbie trying to load data file
    By wab25 in forum Flash Help
    Replies: 2
    Last Post: February 6th, 2004, 04:21 PM
  3. Path Syntax of 'Load Data Infile' in Dreamweaver MX
    By GamalLear in forum MySQL Help
    Replies: 0
    Last Post: January 19th, 2004, 11:03 AM
  4. LOAD DATA INFILE problem
    By dragoonkain in forum MySQL Help
    Replies: 0
    Last Post: January 13th, 2004, 01:18 PM
  5. my comp sux lately , need help from pro's
    By Hykinsel007 in forum Windows Help
    Replies: 2
    Last Post: January 5th, 2004, 01:52 PM

IMN logo majestic logo threadwatch logo seochat tools logo