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 vote141 views1 answer
Sql server epoch to datetime
SQL
1 vote137 views1 answer
Temp table vs variable table in sql server
SQL
0 vote92 views1 answer
Sql truncate table referencing itself
SQL
0 vote145 views1 answer
Sql use with to get value counts and percentages
SQL
0 vote138 views2 answers
Postgresql get last day of month
SQL
3 votes137 views1 answer
Laravel paginate raw sql
SQL
12 votes142 views1 answer
Script to add new column in table sql
SQL
1 vote144 views1 answer
Select users with same username
SQL
0 vote158 views1 answer
SQL joins in python
SQL
0 vote140 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL