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

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

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

How to back up MySQL databases from the command line in Linux Your email has been sent Whether you're running a LAMP stack on Ubuntu or CentOS, you need to back up your MySQL databases. Learn how to ...

I tried using the following commands to shutdown and startup MySQL and although it did, it also changed the permissions on the databases and I could no longer work ...