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

9 votes363 views2 answers
Sql limit to 5 results
SQL
0 vote346 views2 answers
Sql join on wildcard
SQL
0 vote388 views1 answer
Querry mysql by 2 columns
SQL
0 vote363 views1 answer
Declarative base sqlalchemy
SQL
4 votes355 views1 answer
Group by mysql and concatenate string
SQL
18 votes331 views2 answers
Sql comments
SQL
0 vote381 views1 answer
Sql: extract day text from datetime value
SQL
11 votes373 views3 answers
Pl sql example
SQL
14 votes374 views3 answers
Trim sql
SQL
0 vote343 views1 answer
Online sql testing tool
SQL