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 vote398 views1 answer
PostgreSQL types and C# types
SQL
0 vote333 views2 answers
Transaction php
SQL
0 vote325 views1 answer
Mariadb used space
SQL
41 votes435 views6 answers
Alter table add column in SQL Server
SQL
0 vote315 views2 answers
Select limit ms sql
SQL
0 vote350 views1 answer
Mysql make date from 2 column
SQL
0 vote354 views1 answer
Postgresql cast as year and month from timestamp
SQL
1 vote354 views2 answers
Mysql switch case
SQL
0 vote356 views1 answer
On delete set default
SQL
0 vote319 views1 answer
Sql query for getting data with join and count
SQL