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 vote122 views1 answer
Mysql disable query caching
SQL
92 votes326 views6 answers
Substring
SQL
0 vote130 views1 answer
Drop all triggers oracle
SQL
2 votes110 views1 answer
Codeigniter print last sql query
SQL
0 vote134 views2 answers
Return the number of records in a single table mysql
SQL
0 vote120 views1 answer
Mariadb number format
SQL
0 vote122 views1 answer
Groupby error in mysql
SQL
1 vote117 views3 answers
Mariadb add foreign key
SQL
0 vote117 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote141 views1 answer
Mysql join table with a text columns with ids splited by char
SQL