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 vote177 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote229 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote174 views1 answer
SqlFunction does not exist
SQL
-1 vote176 views1 answer
How to change the auto increment in existing table mysql
SQL
23 votes176 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote159 views1 answer
Sql with example
SQL
6 votes204 views5 answers
Oracle list tablespaces
SQL
26 votes170 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote212 views1 answer
IS THEre any difference between using default and := in plsql
SQL
0 vote168 views1 answer
Watch mysql command line
SQL