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

1 vote165 views1 answer
Mysql previous year
SQL
7 votes148 views3 answers
Convert ansi sql
SQL
2 votes141 views1 answer
Oracle list duplicates
SQL
0 vote126 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote154 views1 answer
Mysql remove last character
SQL
5 votes152 views1 answer
Oracle nls instance
SQL
-1 vote133 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote139 views1 answer
Mysql query to check record exists in database table or not
SQL
2 votes140 views2 answers
Run mysql command from bash
SQL
0 vote135 views1 answer
What is between operator
SQL