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

16 votes294 views6 answers
Mysql find duplicates in same table
SQL
1 vote277 views1 answer
Where to locate set password for mysql
SQL
8 votes256 views1 answer
Mac restore mysql database command line
SQL
0 vote257 views1 answer
Difference between varchar and varchar2
SQL
1 vote280 views1 answer
Postgresql round double precision
SQL
0 vote272 views1 answer
Mysql set variable to today's date
SQL
0 vote275 views1 answer
Convert rows to columns in sql server
SQL
0 vote274 views1 answer
Enable sql server full text indexing
SQL
1 vote258 views1 answer
How much every mysql database record takes from diskspace
SQL
2 votes252 views1 answer
Drop table if exists in postgres
SQL