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 vote281 views1 answer
Query to get all primary keys and foreign key
SQL
2 votes281 views6 answers
In in sql
SQL
0 vote300 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
15 votes288 views3 answers
Find duplicate keys in mysql
SQL
15 votes306 views3 answers
Postgresql change column type
SQL
0 vote297 views1 answer
Transaction database with php
SQL
0 vote341 views1 answer
Oracle winter time change
SQL
4 votes285 views2 answers
How to insert ip address in mysql using php
SQL
0 vote282 views1 answer
Add timestamp column to existing table ms sql server
SQL
0 vote317 views1 answer
Firebase sql
SQL