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 vote224 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote246 views2 answers
Sql last updated
SQL
0 vote247 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
0 vote233 views1 answer
Add unique constraint sql server multiple columns
SQL
0 vote249 views1 answer
Mariadb cast null to 0
SQL
-1 vote223 views1 answer
Sql getdate date only
SQL
0 vote236 views1 answer
Unique element in sql
SQL
3 votes240 views3 answers
Create a view postgres
SQL
-1 vote258 views2 answers
Sql truncate number
SQL
1 vote213 views3 answers
String to int mysql
SQL