Category Archives: MySQL

By April 30, 2011

You will need to convert you Excel worksheet to a csv file by saving it as .csv If you have mysql installed locally on your pc , you can run the following query to import your data . *please note you should remove the first column which includes the columns titles. * LOAD DATA local


Read More
By August 09, 2010

Seems it is no longer enough to have localhost in the servers local hosts file (C:\Windows\System32\drivers\etc\hosts) you also have to comment out or remove the IPv6 equivalent. 127.0.0.1 localhost #::1 localhost **this seem to work only when connecting locally ** Thanks Bruce


Read More
By August 09, 2010

– packet 6 bytes shorter than expected in – Client does not support authentication protocol requested by server; consider upgrading MySQL client Error: This means you are connecting to a mysql server using the new hash client while the server is setup to receive the old. You will first need to make sure old-password is


Read More
By January 30, 2010

Incorrect information in file /path/test.frm This indicates that skip-innodb is enabled in the my.cnf file ..


Read More
By October 31, 2009

Error : ERROR 3 (HY000): Error writing file ‘/tmp/MY68ie0h’ (Errcode: 28)   this is due to a storage issue with the partition that is holding /tmp


Read More
1 2 3 4 5