Mysql

I am databases… especially MySQL – get my tips, tricks and analysis here.

Goals for 2011

By in Computing, Iphone, Mysql

Well, a couple of weeks into the New Year, and it’s time for the usual Resolutions. So what are mine this year, well some I am keeping to myself, but a few techie ones remain.

In no particular order I intend to do/get the following:

  • Obtain a Macbook (Air / Pro).
  • Learn how to program the Iphone / Ipad
  • Get a tablet pc (Ipad possibly or windows 7 based one we shall see)
  • New Digital camera to replace the now aging Canon EOS350 – (my current one has suffered from being in -28 and + 40 in it’s working life)
  • Get this Blog back up and running doing the following:
  1. Reviewing Iphone Apps – on the Iphone 4 and Iphone 3g
  2. Document insights into MySQL from the servers I manage
  • Get to grips (finally) with OOP and PHP (come-on I know JAVA so I really should have cracked this already but the old C programming gets in the way).
  • Have a dabble in Cloud Computing – it seems to be here to stay and since 2010 had virtualisation 2011 is Cloud 🙂

That’s it for now – check back to see how I do 🙂

Mysql Error: Error 13 – Can’t get stat of

By in Mysql Tags: , , ,

Error of the day this one – had a script which used Load Data Infile to load the data from a csv file to a MySQL database table – worked fine previously.
After 6 months needed to use it again – everyting seemed fine, except this error kept appearing.

Checked the script – file existed etc… so what had changed?
We had separated out our servers a few months earlier so Mysql now runs on a separate server, this means load data infile can no longer find the file.

To solve this problem use Load Data Local Infile – basically this uses the client (which in this case exists on a server running php) to access the file and pipe it to the mysql server.

The annoying thing about this error is that finding the solution isn’t that easy – as most people say that it’s file permissions etc.. when it could be that the SQL server is actually on a remote location and so you need to use LOAD DATA LOCAL INFILE (especially since in larger companies servers tend to be specialised).

NB Due to security settings you cannot usually use LOAD DATA LOCAL INFILE if the file is on the same server as the mysql – then you need to use LOAD DATA INFILE.

Anyway hope this helps someone else like me someday.