Re: LOAD DATA INFILE... ERROR DBNAME.BACKUP_LOG DOES NOT EXIST

[Bridget Franklin]

I can even do the following:
rename the table .. 'table_hold'
create the table again 'table'
do the load without the REPLACE or IGNORE option
then do :

INSERT IGNORE INTO TABLE (SELECT * FROM TABLE_HOLD)

and it works fine... it only complains when I use the REPLACE or IGNORE in the LOAD DATA INFILE command....

So I have a work around but its a "PITA" workaround....

Would still like to know why it's doing what it's doing all of a sudden..