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 vote345 views1 answer
Backup a table in sql
SQL
1 vote348 views1 answer
Scaffold mysql database
SQL
2 votes328 views3 answers
Mysql cheat sheet
SQL
-1 vote352 views1 answer
Add bool column in sql
SQL
1 vote307 views1 answer
Ms sql how to see active job current run time
SQL
0 vote358 views1 answer
CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
SQL
0 vote372 views1 answer
Do you know sql
SQL
0 vote350 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote327 views1 answer
Oracle list all stored procedures
SQL
0 vote426 views1 answer
Wordpress make wp user in db
SQL