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 vote199 views1 answer
Postgresql append array
SQL
37 votes162 views3 answers
Duplicate records in sql
SQL
0 vote151 views1 answer
Go install mysql
SQL
0 vote161 views1 answer
Mysql filter based on datediff
SQL
0 vote172 views1 answer
Sql cmd no truncate
SQL
27 votes182 views3 answers
Mysql show tables in database
SQL
0 vote175 views1 answer
Where field is null sql knex
SQL
0 vote163 views1 answer
Sql on-premises
SQL
0 vote149 views1 answer
Luu ckeditor vao mysql
SQL
14 votes148 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL