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

1 vote294 views1 answer
Postgres upgrade to superuser
SQL
1 vote114 views1 answer
Sql query row number group by
SQL
2 votes99 views2 answers
Oracle create table if not exists
SQL
4 votes114 views2 answers
Postgre sql create table
SQL
1 vote99 views1 answer
Oracle finding duplicate records
SQL
0 vote106 views1 answer
Dbms_output sql developer
SQL
1 vote102 views1 answer
Mysql check string don't have number
SQL
0 vote100 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote102 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
6 votes118 views1 answer
Oracle rank
SQL