1

Extract name of file without extension in shell script

view story
linux-howto

http://unix.stackexchange.com – 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 piRNA.txt the command would look like mysql -u root -p -e "LOAD DATA LOCAL INFILE 'piRNA.txt' INTO TABLE piRNA" -D rn4 How do I do this? To make the answer useful for others, please do not just gi (HowTos)

missing's picture
Submitted by missing on 11/26/2012

Stories similar to Extract name of file without extension in shell script

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'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?

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.

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 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?

Problems and Doubts with Mysql 10 weeks 5 days 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.

I need to get the exact filepath, filesize, and date modified and store it in a mysql table.

If I do ls command, it gives me an output that is quite difficult to parse properly to be able to load it into a mysql table.

What would be the best way to get the filepath, size, and date modified and store it in a mysql table (currently, I am using load data infile).

I have a table packages which holds a couple of thousands of rows, there's a mysterious problem with it, it's that I can see it exists from 'show tables' but I when I do 'select ... from packages', mysql says the table doesn't exist. What's wrong?

error msg：

Cannot find or open table market/ma_package from the internal data dictionary of InnoDB though the .frm file for the table exists.

Hello, I want to install piwik and have some questions about Slackware PHP,MYSQL options.

I'd configure my Apache, PHP, Mysql from how-to-run-apache-php-mysql-on-startup-and-install-phpmyadmin-slackware-12-2, but have Slackware 13.1 PDO and MYSQLI are already in my php.ini.

Code: extension=bcmath.so extension=bz2.so extension=calendar.so extension=ctype.so extension=curl.so extension=dba.so e