MySQL Forums
Forum List  »  Other Migration

Re: Insert data from excel files to database table
Posted by: Nick Roper
Date: July 21, 2004 02:54AM

OK, in order to use the LOAD DATA INFILE command you need INSERT privileges for the table. As you are able to execute INSERT statements stored in a text file, let's assume that you have this privilege.

If the file that you are trying to load with LOAD DATA INFILE is located on the same machine as the mysqld server, then you will also need MySQL FILE privileges - which you may not have. You might be able to get round this by connecting to mysqld from a mysql client on another machine and then using the LOAD DATA LOCAL INFILE syntax to load the file from the client host. You will need read access to the file, but you shouldn't need MySQL FILE privileges on the server.



--
Nick Roper

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.