automated csv import to mysql server

Strange Swan answered on November 6, 2020 Popularity 7/10 Helpfulness 2/10

answer automated csv import to mysql server

automated csv import to mysql server

Comment

#!/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"

Popularity 7/10 Helpfulness 2/10 Language sql

Source: stackoverflow.com

Tags: csv-import sql

Link to this answer
Share Copy Link

Contributed on Nov 06 2020

Strange Swan

0 Answers Avg Quality 2/10

automated csv import to mysql server

Contents

More Related Answers

automated csv import to mysql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.