MySQL Forums
Forum List  »  Performance

Re: insert or load ? best practices and performance
Posted by: Rick James
Date: September 20, 2010 06:28PM

> perror 2
OS error code 2: No such file or directory

forward slashes? backward slashes? spelling of filename?

I deliberately put the RENAME after the LOAD -- that way the old table would be available until the instant the RENAME is done. (This may not be important for your situation; it is for some people.)

Options: ReplyQuote




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.