Import csv to mysql

Automated csv import to mysql server

#!/bin/bash
IMPORTED_FILE_PATH=/path/to/your/imported/file.csv
TABLENAME=target_table_name
DATABASE=db_name
TMP_FILENAME=/tmp/${TABLENAME}.cvs
# do nothing if imported file does not exist
[ -f "$IMPORTED_FILE_PATH" ] || exit 0
# if temporary file exists, then it means previous import job is running. Also do nothing
[ -f "$TMP_FILENAME" ] && exit 0
# Move it to tmp and rename to target table name
mv "$IMPORTED_FILE_PATH" "$TMP_FILENAME"
mysqlimport --user=mysqlusername --password=mysqlpassword --host=mysqlhost --local $DATABASE $TMP_FILENAME
rm -f "$TMP_FILENAME"

Source: stackoverflow.com

Similar codes

0 vote264 views3 answers
ChAnge TABLE name apex oracle
SQL
13 votes266 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
4 votes299 views1 answer
Mysql store ip address
SQL
22 votes262 views3 answers
Sql cheat sheet
SQL
0 vote260 views1 answer
Initcap in sql
SQL
9 votes284 views4 answers
Mysql set id auto increment
SQL
11 votes264 views4 answers
Round in sql
SQL
3 votes417 views9 answers
Linq to sql converter online
SQL
0 vote285 views1 answer
Sql log file inof
SQL
0 vote287 views1 answer
How to run mysql on terminal mac
SQL