thanks for the responses, It was the fact that the user i was connecting as didnt have write permissions. That cant be changed so I just have a cron job execute the query write it into a file that ...
How to add data into MySQL tables from the command line Your email has been sent So you’re new to MySQL database administration. You’ve probably already installed ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results