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

The MySQL query language works in that it constructs data records by selecting data from already existing data records. Many people use MySQL databases to power marketing and sales websites, ...

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

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

For database administrators (DBAs), keeping databases running at peak performance can be a little like spinning plates: It takes agility, concentration, quick reactions, a cool head, and an occasional ...