To import large amounts of CSV data from a file into a MySQL database you can use the LOAD DATA [LOCAL] INFILE command. There are some caveats using this command having to do with security. In order for LOAD DATA to work you will have to enable the command on both the server and client. To do this for the server, you can edit your ...
[...]
Categories
Latest posts
- Using gp.vcsdevelop for vcs dependencies in zc.buildout
- Django "view-permissions" for related objects
- Openfiler permission problems with shares on MacOSX and Windows
- Allow squid/mod_wsgi to pass the HTTP_AUTHORIZATION header to Apache
- Using Fabric to update a remote svn checkout with ssh public key authentication
- Proper access rights with SSH+SVN
- Allow ssh-agent to work when using sudo
- Using a jumpbox with subversion
- Installing Openfiler - Part 2
- Using mysql load data infile with django
