| jessupx | hey guys what does it mean if mysql ignores a limit 0,1 after a select statement? |
| f00li5h | "ignores"? |
| jessupx | oh, it was my bad.. I had a quote in the wrong place it was doing the full select, not limiting to only 1 |
| makhan | is there any way to get the values of a table in a variable in c program |
| ToeBee | sure |
| makhan | can u please tell me how? |
| ToeBee | it is called an API... http://dev.mysql.com/doc/refman/5.0/en/c.html |
| makhan | yeah i am using the api and i am able to connect and make the queires how can i collect the result of queries into a variable |
| ToeBee | usually you suck out individual values into integer/string/etc variables not sure if the c api has functions to pull out an entire row at a time as an array or not. kind of doubt it |
| soundsoldier | MacPlusG3: ok, how do you approach synchronization between the mysqld nodes for stuff like client permissioning |
| MacPlusG3 | soundsoldier: generally manually - or through scripts soundsoldier: theoretically can do it with replication as well |
| Isil`Zha | hallo. i can't connect to my local mysql server. error is "ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)". my main problem now: i don't seem to have such a file anywhere on my disk. i tried to use --host=localhost as well to get it using tcp/ip. didn 't change anything |
| ToeBee | is the server running? |
| Isil`Zha | yes according to the initscript it is i used the one in /etc/init.d/ (gentoo) |
| ToeBee | what about according to top? or rather ps ps ax | grep mysqld |
| Isil`Zha | ps doesn't show it. but i don't understand why the initscript returns "* WARNING: mysql has already been started." |
| ToeBee | it may have crashed check the logs in /var/log/mysql/ |
| SomethingRotten | http://hashphp.org/pastebin?pid=14785 I dont understand why this doesnt work |
| ToeBee | Isil`Zha: if it really isn't running you can reset the init script with /etc/init.d/mysql zap |
| Isil`Zha | hmm well: mysql.log is empty, mysql.err only has "060704 20:06:07 mysqld started", which is strange because it doesn't mach the time i just restarted it. mysqld.err finally complains about innodb having problems with the server being downgraded from a version higher than 4.1 to 4.0 (had to do this because i wanted to replicate a remote environment locally) |
| chadmaynard | SomethingRotten: 12: $result = mysql_query("SELECT * FROM tblHome WHERE date = '$date'"); !tell SomethingRotten about quotes |
| the_wench | SomethingRotten Use ` around identifiers (database/table/column/alias names) and ' around strings and dates. MySQL does allow " for strings, but ANSI standard uses " for identifiers (which you can enable with ANSI QUOTES option) |
| Isil`Zha | ToeBee: did this. no changes. ps still doesn't show it. the script tells me it was successful though |
| ToeBee | well I'm not totally sure what is going on but I would recommend figuring out what that innodb error is all about |
| Isil`Zha | eventually i don't care about the data which is inside. is there an easy way to just delete everything? if the existing dbs really stop it from working this should fix it i hope |
| chadmaynard | Isil`Zha: delete everything inside the datadir and then run mysql_install_db |
| Isil`Zha | chadmaynard: thanks |