chancemedia/mbzdb — Issue #38: load_data also tries to load data from directories
Author: splitfeed
Created: 2011-11-11 07:10:06+00:00
State: open

I accidentally left an mbdump directory within mbdumb and got the following error:
Thu Nov 10 17:49:04 2011: Loading data into 'mbdump' (52 of 81)...
DBD::mysql::db do failed: Table 'ngsdb.mbdump' doesn't exist at src/functions.pl line 92, line 2.
SQL: 'LOAD DATA LOCAL INFILE 'mbdump/mbdump' INTO TABLE `mbdump` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' STARTING BY '''

It was obviously my mistake, but it could have been avoided and spared me the time to do it all over ;)