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 vote181 views2 answers
How to save result of sqlite query in a table
SQL
2 votes200 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes206 views1 answer
Define REGEXP?
SQL
0 vote213 views1 answer
Oracle to_number
SQL
11 votes180 views2 answers
Having clause in sql
SQL
13 votes170 views2 answers
Sql count distinct group by
SQL
0 vote189 views1 answer
Get schema of table sql
SQL
0 vote191 views1 answer
Sql comand for removing data from table
SQL
10 votes221 views2 answers
What is database
SQL
1 vote174 views1 answer
How to delete record sql delphi
SQL