Re: - Messed up with my.cnf file.

[Chaitannya Mahatme]

After a hard day's work i figured out how it is installed.. I followed the instruction in INSTALL-BINARY (Folks follow each and every thing carefully it does work perfectly). Things worked fine. I started the demon and it worked fine.. So far so good. I created a database, table having two columns of polygon. inserted some data into it.. Everything worked fine. When I ran a select query for a GIS function intersection


select astext(intersection(geomfromtext('polygon((0 0, 1 0, 0 1, 0 0))'), geomfromtext('polygon((0 0, 1 1, 0 2, 0 0))')));


I got a message "MYSQL connection lost.. " And this happened everytime i ran a select query. So I thought that there is an error in my.cnf file. I changed it and now when i run the demon I get this message.

mysqld_safe mysqld from pid file /usr/local/mysql/sadakmap.pid ended

Now i checked this location (/usr/local/mysql/). There is no pid file (infact there are no files in this location). What to do..



Edited 1 time(s). Last edit at 12/03/2009 05:47AM by Chaitannya Mahatme.