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 vote127 views1 answer
Distance calculator from lat long sql query
SQL
16 votes122 views3 answers
Jwt secret key generator laravel
SQL
0 vote106 views1 answer
Mysql last 6 months
SQL
-1 vote132 views1 answer
Ms sql select datetime as date
SQL
1 vote129 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
3 votes119 views3 answers
Your password does not satisfy the current policy requirements
SQL
0 vote154 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote141 views1 answer
Sql and
SQL
6 votes122 views3 answers
Mysql first day of year
SQL
1 vote124 views1 answer
Error code 1292 mysql workbench
SQL