LOAD DATA errors
I am attempting to do a LOAD DATA from a query.
The query context is:
$sq1="LOAD DATA INFILE '$file_in' INTO TABLE td1 FIELDS TERMINATED BY '|' ENCLOSED BY '''' TERMINATED BY '\n'";
When running the query, it's spitting an error of:
Woops... sql # 1 MySQL Error:Can't get stat of '/fis/mantis/common/www/eos2/backup/load/2011-06-22/dbq/td1.load' (Errcode: 2)
Any suggestions would be greatly appreciated as I want to move to the load file format for data backup and recovery.
-Tim
Subject
Written By
Posted
LOAD DATA errors
June 22, 2011 09:42AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.