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 vote173 views3 answers
Find below average salary in sql
SQL
2 votes183 views2 answers
Mysql find max value row
SQL
0 vote196 views2 answers
List all constraints in postgres
SQL
8 votes170 views1 answer
Oracle add months to sysdate
SQL
0 vote186 views1 answer
Plsql check how much space all databases are consuming
SQL
1 vote171 views1 answer
Postgres convert exisiting column to text
SQL
0 vote160 views1 answer
Go install mysql
SQL
4 votes160 views3 answers
Order by value mysql
SQL
2 votes189 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote159 views1 answer
Access denied for user 'root'@'localhost' workbench ubuntu
SQL