1

[ubuntu] MySQL and local-infile

view story
linux-howto

http://ubuntuforums.org – I'm trying to load a csv file into mysql using the Load Data Local Infile command in the mysql workbench and I'm getting the errror. ERROR 1148 (42000): The used command is not allowed with this MySQL version I added the local-infile=1 line to the my.cnf file, but continue to get the error. Do I need to do something else to be able to load a csv file? Is there a better way to load csv files into msql? Thanks. (Hardware)

dayu's picture
Submitted by dayu on 10/08/2012

Stories similar to [ubuntu] MySQL and local-infile

How would I do the following command, with a local file, on a remote database (different machine) ?

$MYSQL_PATH/mysql -u root -h remote.net files -e " LOAD DATA INFILE '$1' INTO TABLE $TABLE_NAME FIELDS TERMINATED BY ',' (size, @d2, @d3, @d4, @d5, path)

The problem seems to be that the INFILE at /tmp/infile.txt is not being recognized remotely.

I have a metric boatload of .txt files I'd like to load into a database.

The tables have the same name as the .txt files, but without the extension.

So I'd like to execute the command

for f in *.txt; do mysql -u root -p -e "LOAD DATA LOCAL INFILE '$f' INTO TABLE $f" -D rn4; done

However, the last $f is giving me headaches as I want it to only use the name, not the extension.

So for the file

How do I create a local backup of a remote Amazon RDS MySQL database? What I need to know is how to make a complete full local backup of a MySQL database (not a remote Amazon snapshot) that can be used to restore to a new database anywhere, on any MySQL server (same version of course).

NOTE: I know how to import data from a flat file via MySQL.

Problems and Doubts with Mysql 11 weeks 16 hours ago

Hi guys,I'm here again because I have one problem and one doubt.1. I use my web server running archlinux64 of course, to host an Electronic Health Record called OpenEMR. The thing is it has a feature where it loads some files and install them automatically, which are the ICD9 and ICD10 codes health care providers need.

MySQL command I have so far:

load data infile 'data.txt' into table foo (column_foobar);

data.txt:

bar1 bar2 bar3

Note the tab at beginning of each line. How can I ignore the tab with MySQL so that bar1, bar2, bar3 gets loaded in column_foobar?

very high load mysql load seen for 5-6 hours daily, when daily compressed backups run. load seems to be with mysql process. Typical ps snaphot is as;

mysql 6896 14.2 4.0 802300 373804 ?

I have stack overflow data in an xml file listed below, I want to insert it into mysql database using LOAD XML INFILE , it executes but insert blank/null values in table:

<badges> <row Id="82946" UserId="3718" Name="Teacher" Date="2008-09-15T08:55:03.923" /> <row Id="82947" UserId="994" Name="Teacher" Date="2008-09-15T08:55:03.957" /> <row Id="82948" UserId="3372" Name=

MySql - mysql-workbench problem 2 years 43 weeks ago

Hi Guys,

I am looking to use the mysql tool mysql-workbench to administer mysql.

I downloaded the latest version from the MySql website, the fedora rpm. I used rpm2tgz to create a slackware package. Install seemed to go okay.

When I tried to run the mysql-workbench tool I got the following message.

I was setting up a soft link in linux. Here were the steps I followed:

> groupadd mysql > useradd -g mysql mysql > cd /usr/local > gunzip /home/Tim/Download/mysql.....gz | tar xvf - > ln -s /usr/local/mysql.... mysql