
Hi All Eversince I updated my system; The following blockbased import script doesn't work anymore: #!/bin/bash BLOCKSIZE=250000 #RECORDCOUNT L=$(wc -l $1 | awk '{ print $1}'); #MERGE BLOCKS INTO TABLE for I in $(seq 0 $BLOCKSIZE $L); do echo "$BLOCKSIZE $I $1/$L loading... "; mclient --time -d test --statement="COPY $BLOCKSIZE OFFSET $I records into \ wptool.wpstats from '$1' using delimiters ' ','\n','' null as '';"; echo "$BLOCKSIZE $I $1/$L loading...finished "; done Returns the following error (it used to work): IOException:streams.open:Could not open file ERROR: mnstr_open: could not open file '/var/www/loadstats/pagecounts-20110102-160000' The script is started through: sh importintodb.sh /var/www/loadstats/pagecounts-20110102-160000 Does anyone has some thoughts on this, or should I report a bug? I would really like to use commandline, as the hourly imports are 6M records big... The .monetdb file is placed locally and automatically authenticates with monetdb (admin). Lang=SQL, history=yes Regards Lex Slaghuis