Search code examples
savehostingmysql-error-1045select-into-outfile

SELECT * FROM .. INTO OUTFILE and save on hosting or send FTP - HOW TO?


I need help. When I try this - SELECT * FROM .. INTO OUTFILE - on local, everything is ok. When I try it on my hosting, I receive error message #1045 - Access denied for user '..'@'%' (using password: YES) . How to do it make it work? Thanks for any advice :)


Solution

  • I finally solved the problem by using fputcsv() - simply by using the SELECT, from the database i take field up and in the PHP script I created CSV file :)