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 vote263 views1 answer
Sql select data from one database and insert into a different database
SQL
0 vote265 views1 answer
Postgresql interview questions
SQL
4 votes237 views2 answers
How to count items with same name in sql
SQL
4 votes290 views4 answers
Remove duplicate old value in mysql
SQL
0 vote254 views2 answers
Mysql regexp match word
SQL
0 vote232 views1 answer
Sqlite3 not commit
SQL
0 vote272 views1 answer
Group by 15 minute interval sql server
SQL
3 votes261 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote305 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote230 views1 answer
Mysql sleep connections
SQL