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 vote322 views1 answer
How to make a select in sql
SQL
8 votes100 views2 answers
Update sql server from another table
SQL
1 vote111 views1 answer
Oracle sql first day of year
SQL
7 votes101 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote122 views1 answer
Postgres change the name of schema
SQL
0 vote103 views2 answers
Cascade syntax in sql
SQL
0 vote100 views1 answer
Sql grant select only
SQL
0 vote101 views1 answer
Plpgsql raise notice
SQL
1 vote125 views1 answer
Oracle activate job
SQL
6 votes109 views2 answers
Insert into select mysql
SQL