vsphere_hosts_import.sh

#!/bin/bash

mysql -uvsphere -p$VCENTER_PASSWORD --database=$DB_NAME --host=$DB_HOST -e "LOAD DATA LOCAL INFILE '$CSV_FILE' INTO TABLE $DB_TABLE  FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'  IGNORE 1 LINES"