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 votes111 views1 answer
Insert from table tsql
SQL
0 vote137 views1 answer
How to set up an anonymous function to variable in swift
SQL
1 vote130 views1 answer
Postgresql create table with timestamp
SQL
0 vote129 views1 answer
Mssql + bit + in python orm
SQL
0 vote102 views1 answer
Mysql start of today
SQL
4 votes111 views2 answers
Dbms_scheduler stop job
SQL
0 vote119 views1 answer
Format the money fied with comma in international system using sql
SQL
1 vote115 views1 answer
Mysql not supported auth mode
SQL
0 vote122 views2 answers
Sql join on comma separated field
SQL
12 votes128 views2 answers
Select into insert sql server
SQL