Skip to content
This repository has been archived by the owner on Aug 14, 2019. It is now read-only.

load_data also tries to load data from directories #38

Open
splitfeed opened this issue Nov 11, 2011 · 3 comments
Open

load_data also tries to load data from directories #38

splitfeed opened this issue Nov 11, 2011 · 3 comments
Milestone

Comments

@splitfeed
Copy link

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 ;)

@hectoras
Copy link
Contributor

I've not tested it, but I think adding this on line 102 would do the trick:

next if(-d "./mbdump/$table");

@hectoras
Copy link
Contributor

I've issued a pull request for this: dea91ca

@hectoras
Copy link
Contributor

I think this can be closed now

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants