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 vote184 views1 answer
Mysql c commands
SQL
0 vote173 views1 answer
R2dbc-postgresqldriver dependency
SQL
6 votes184 views2 answers
Difference between join vs union
SQL
0 vote235 views1 answer
What is metadata in sql
SQL
1 vote189 views1 answer
Error cs1061 'dbcontextoptionsbuilder' does not contain a definition for 'usesqlserver'
SQL
0 vote181 views2 answers
Get all index postgres
SQL
1 vote185 views1 answer
Sql upsert
SQL
0 vote202 views1 answer
Sql out file formate
SQL
0 vote198 views1 answer
Select * from mysql.proc
SQL
3 votes171 views1 answer
Export postgres database linux
SQL