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 ...

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...

I recently was talking to someone over IRC who was helping me with a PHP app that was giving me trouble. The extremely helpful individual asked me to let him know the value of a certain field in a ...

MySQL database servers may not come with graphical administration tools, but that is the price your small business pays for free database software. The fact that MySQL's standard administrative tool ...

The MySQL community is a hotbed of free, open source tools to enhance the performance and health of your MySQL systems MySQL is a complex system that requires many tools to repair, diagnose, and ...