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 vote324 views1 answer
Postgresql substring last
SQL
0 vote278 views1 answer
Dump only schema
SQL
6 votes324 views1 answer
Postgresql add enum value
SQL
0 vote303 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
9 votes298 views2 answers
Sql limit order by
SQL
0 vote257 views1 answer
Calculate discount from original price sql
SQL
0 vote304 views1 answer
ORACLE PARSE STRING
SQL
0 vote304 views1 answer
Less than and between in sql query
SQL
0 vote340 views1 answer
Create-table-with-index-organization
SQL
1 vote292 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL