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 vote180 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote204 views1 answer
Get first monday of month sql
SQL
9 votes234 views3 answers
Pyodbc connect to sql server
SQL
2 votes214 views1 answer
Mariadb json select
SQL
5 votes208 views2 answers
Postgresql insert select
SQL
-1 vote195 views2 answers
Full join sql
SQL
5 votes196 views3 answers
Truncate function in sql oracle
SQL
3 votes216 views2 answers
Truncate all tables
SQL
-1 vote199 views2 answers
How to select the lowest values from table per client sql
SQL
2 votes203 views1 answer
Mysql time ago difference
SQL