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 vote389 views1 answer
Site:av.ru "files"
SQL
0 vote337 views1 answer
Less mysql display
SQL
0 vote316 views1 answer
Count the table indatabase
SQL
10 votes426 views4 answers
Sql server pagination
SQL
5 votes341 views1 answer
Oracle asynchronous update
SQL
0 vote322 views1 answer
Como hacer un select entre fechas mysql
SQL
6 votes317 views1 answer
To count number of rows in SQL table
SQL
0 vote319 views1 answer
Turn on foreign keys check mysql
SQL
0 vote324 views1 answer
List mysql tables and views
SQL
6 votes319 views2 answers
Mysql check auto increment value
SQL