Re: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Il 11/04/2012 10:51, Ganesh Kumar ha scritto: Hi Guys, I am using debian squeeze it's working good, I am trying to install mysql-server. mysql-server installation successfully but didn't start root@devel:~# /etc/init.d/mysql restart Stopping MySQL database server: mysqld. Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed! Hi, look at /var/log/daemon.log, here you will find the reason. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
Il 01/03/2012 11:03, javad bakhshi ha scritto: Hi, I am trying to load data into my table from a very large file but after some time I get this error: ERROR 2013 (HY000): Lost connection to MySQL server during query My file size is around 4G and I have 220M lines in my file which have to be loaded in to my table. I have 10 of these files which have to loaded in the same table. My MySQL version is 5.1.59, I have changed the max_allowed_packet to 346030080. any ideas how I can solve this problem? Best regards, Javad Bakhshi, In order to resolve the problem you may need to increase these two values in mysql.ini or my.cnf, and restart mysql: wait_timeout = 28800 connect_timeout = 28800 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Illegal non geometric aswkb value found during parsing
Hello, I've migrated a MySQL 5.1.45 on Windows 2003 (32 bit) to a MySQL 5.1.55 on Windows 2008 (64 bit) by mysqldumping alla databases. All seems ok but I have a table with a column coordinate of type geometry on a table address. The following query now fail: SELECT *, X(coordinate) as longitudine, Y(coordinate) as latitudine , GLength( LineStringFromWKB( LineString( AsBinary(coordinate), AsBinary(PointFromText('POINT(0 0)')) ) ) ) AS distance FROM address The error is: Illegal non geometric 'aswkb(`cappuccino`.`address`.`coordinate`)' value found during parsing If I import the table on another server (Debian 6.0, MySQL 5.1.45 32 bit) the same query works without problem, I've already reimported from the same dump the table on the new server without success. On the old server the query still works. I have no idea on what is happening, thanks for any suggesion.