need help with LOAD DATA INFILE

2012-07-11  Source: Original Site  Category:PHP  Views:0 

Advertisement

I'm trying to convert an MS Access DB to MySQL. I exported the Access db to a txt file, with fields delimited by the '~' character. I put the txt file in the bin directory, and ran the following code from the command line:

C:\MySQL\bin>LOAD DATA INFILE 'scholarships.txt' INTO TABLE scholarships FIELDS TERMINATED BY '~'

I did a search on the boards and read that this is a good way covert DBs. It seems fairly simple and straight forward, but I can't get this command to work. I also tried a few other variations of this code, but they all resulted in the following error:

'LOAD' is not recognized as an internal or external command, operable program of batch file.

I don't know what that error is telling me, so I'm not sure what to do to correct it. Any help is appreciated.

Related articles
  • need help with LOAD DATA INFILE 2012-07-11

    I'm trying to convert an MS Access DB to MySQL. I exported the Access db to a txt file, with fields delimited by the '~' character. I put the txt file in the bin directory, and ran the following code from the command line: C:\MySQL\bin>LOAD DATA I

  • MySQL Help with "LOAD DATA INFILE" 2013-07-06

    Please help me... I'm going crazy now. I am trying to use the LOAD DATA INFILE command to load a CSV file into my table. I created a table called brdata, with the fields below and everything with NOT NULL VARCHAR(18) INT(4) INT(4) INT(4) INT(4) INT(4

  • Help - with LOAD DATA INFILE 2013-05-21

    I have a 2 part question. First, I simply can't get the LOAD DATA INFILE command to work. I'm trying to load a txt file into a very simple database. I get the following error When I input: LOAD DATA INFILE "cars.txt" INTO TABLE cars I get this error:

  • MySQL Help with "load data infile" statement 2014-12-02

    I'm having trouble with the load data statement I've written. It's not returning an error, but no data is being imported. This is what I'm running: load data infile 'filename.csv' into table table.table1 fields terminated by ',' lines terminated by '

  • MySQL need help with LOAD DATA 2015-06-05

    all, im newbie and have a problem with the LOAD DATA heres my Code: LOAD DATA LOCAL INFILE 'D:/example.csv' REPLACE INTO TABLE articles(Title,Description_Short,DisplayPrice,Img_url,Deeplink1,ProductCategory,ProductCategoryName,Anbieter) FIELDS TERMIN

  • need help with LOAD DATA Query 2012-02-27

    Hello I am trying to write a load script that logs into an ftp, downloads a file, then I have the below code which takes that file and does a load data query and is suppose to load it into my database. I ave had people check my code and they say it l

  • Need help with loading data to Website 2013-05-13

    I've had a website developed for On-line sales & i'd like to load prod. info into it (30000 records or prod.s) How can i achive this ? Is there a script that i can use to load the data possibly from Excel ? Pls. advise - Mave

  • i need help with the data control 2014-03-06

    I need help with the Data control in Visual Basic 6. Is it possible, when i'm using a MS Access as a source for the Data control, to display a specipfic cell. I don't want to scroll thru the rows in a certain DataField, i wan't to go directly to a sp

  • MySQL Question with LOAD DATA INFILE 2014-03-12

    I am using Datetime datatype with a default NOW() in the table and as i want to make use of LOAD DATA INFILE method to populate this table. TABLE STRUCTURE ------------------ CREATE TABLE TEST ( create_date datetime default now() ); mysql> insert

  • MySQL Incomplete UPDATE after bulk-loading with LOAD DATA INFILE 2012-02-17

    would be glad if somebody could help me with my problem: I'm bulk-loading a lot of CSV-data (~400.000 rows) into a table X_new using the LOAD DATA INFILE mechanism of MySQL. After that I commit an UPDATE statement which updates all rows in table X wi

  • MySQL CSV file with , in a field. how to load with LOAD DATA INFILE command? 2013-02-21

    I have created a simple shell script to load "test.csv" into an mySQL table. The data looks like this; "joe","smith" "don","jackson" "rich,sun","wright" Here is the LOAD DATA INFILE command I am using; "LOAD DATA INFILE 'data.csv' INTO TABLE jras_int

  • MySQL Problem with LOAD DATA INFILE 2013-08-30

    I am new to MYSQL, so please forgive my ignorance. I have a table called: tbltest with 2 fields: ProcDate (datetime), TranNumber (varchar(6)) I am trying to input this file (test.txt): 2006-12-26 0:00:00 000161 2006-12-26 0:00:00 000162 The command I

  • MySQL Access Denied with LOAD DATA INFILE 2014-02-12

    I'm trying to use the LOAD DATA INFILE statement to load data into a new database. I created the database using the ROOT id, then used... CREATE DATABASE SWAP; GRANT ALL PRIVILEGES ON swap.* to 'SWAPUSR'@'localhost' IDENTIFIED BY 'password' I then qu

  • Need help with reading data to array and recursion 2014-06-04

    guys I need help with a program for school. It involves a menu to access sub programs and use of recursive techniques as well as 2D arrays and traversing. Here's the requirements: In this program, you are to create a menu-driven program that allows t

  • using AUTO_INCREMENT with LOAD DATA INFILE 2014-08-05

    Hello I am using LOAD DATA INFILE to load data into a table. This is how the table is defined: CREATE TABLE people ( ID INT UNSIGNED NOT NULL AUTO_INCREMENT, Name VARCHAR(255) NOT NULL, Address VARCHAR(255) NOT NULL, PRIMARY KEY (ID) ) ENGINE=MYISAM

  • help with LOAD DATA command please 2015-06-03

    I am having trouble with this command. I am using win 98, connecting through telnet to my isp. I have tried a number of things: 1) tried to load data with phpmyadmin 2) tried manually loading through telnet: LOAD DATA INFILE '/home/afp/brandmodel.txt

  • Problem with mysql CLI with LOAD DATA INFILE 2012-07-17

    mysql --local-infile=1 -h localhost --port=3306 -u phillip --password=whatever -D home -e 'LOAD DATA LOCAL INFILE ''/home/phillip/docs/data.csv'' INTO TABLE people FIELDS TERMINATED BY '','' ESCAPED BY ''\\\\'' OPTIONALLY ENCLOSED BY ''"'' LINES TERM

  • Help! LOAD DATA INFILE, GoDaddy Issues 2012-10-11

    I use a Linux, shared hosting setup on GoDaddy. I am trying to bulk load a text file into an existing table using the LOAD DATA INFILE command. Everything works great on my development platform but when I run the script at GoDaddy, I get the error: "

  • MySQL Error with LOAD DATA INFILE 2013-03-07

    I am trying to load a pipe delimited file into my database. The fields in my text file are not in the same order as my database columns, and the number of columns are not the same. Basically I am receiving listing of products from different clients o

  • need help with importing data 2013-05-02

    I need help with an import. Data is represented in record sets. I can import the data into excel and see it line up, I can not figure out how to import it into access 2000 or 2003. Here is a sample of the data in a tsv file format. I have included a