Datei dbimport.sql:
load data local infile './texte_out/ere.csv' into table tokens fields terminated by '\t' lines terminated by '\n' ;
Datei dbimport.sh:
#!/bin/sh # WDIR="R:/SoSe_15/LV-Riepl_Luecke-LIPP/Material/Buerk" # WDIR="H:/Buerk WDIR="U:/SoSe_15/LV-Riepl_Luecke-LIPP/Material/Buerk" export WDIR cd $WDIR echo "Importing file ..." echo "" C:/Programme/MySQL/MySQL\ Server\ 5.6/bin/mysql -h gwi-sql2.gwi.uni-muenchen.de -P 3307 lipp_sbuerk -u LIPP_SBuerk -pPASSWORT < dbimport.sql echo "" echo "... finished." echo "" exit 0