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

2 votes352 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
0 vote408 views1 answer
Get initial in sql
SQL
1 vote322 views2 answers
Mysql SELECT
SQL
0 vote338 views1 answer
Mysql docker image for macbook m1
SQL
6 votes349 views5 answers
Mysql get last insert id
SQL
13 votes381 views4 answers
Mysql remove foreign key constraint
SQL
-1 vote426 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote361 views1 answer
Java mysql swing example
SQL
0 vote339 views1 answer
What is the difference between now() and current_date()?
SQL
3 votes353 views3 answers
Start postgresql ubuntu
SQL