| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> this is basically what i'm trying to acomplish: http://pastebin.com/650825 but i can't get it to work the way i want
<1> =o
<2> good morning
<1> good morning
<1> I've got what I hope isn't a dumb question... when I try to start mysql, I get an error message
<1> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
<3> !perror 2
<4> System error: 2 = No such file or directory
<5> I'm trying to move a formerly working RoR app to another box and getting this error "Mysql::Error: Lost connection to MySQL server during query: SHOW FIELDS FROM sessions" -- any ideas why?
<5> I can connect just fine from the command line
<1> followmearound: I'm still new to RoR... do you think it could be because your ... er.. model doesn't have the right connection information to your DB?
<1> you know, like username/p***word/filename/etc...
<5> could be ... but that's al lcorrect
<6> followmearound: I recall having similar problems, and it turned out to be because of much different mysql server and client versions. Very old mysql client software with brand new mysql server for example
<1> followmearound: I know I had a similar problem with a php app I was writing last week... I had thought I had configured my app properly, but I hadn't configured mysql properly
<5> hmm, yea ... okay ... needed a newer mysql-ruby lib
<5> thanks
<1> I had failed to use mysqladmin properly to set up my user accounts
<7> Hi, i'm trying to use mysql_real_escape_string from my C application like: mysql_real_escape_string(&mysql,escapequery,to_go,sizeof(to_go)); but it don't work, someone have any idea why?
<6> JFDionne: I am not sure, but I do not think that this is mysql issue
<7> Urgleflogue I know, but that function require a const char * .. is there any way I can convert my char * ?
<1> Ok, this isn't cool... any suggestions as to why mysql.sock does not exist on my computer, and possibly how to replace it?
<1> fscking yast2 is letting me down
<6> JFDionne: I am not sure what exactly you are doing, but might want to take a look here: http://dev.mysql.com/doc/refman/5.0/en/mysql-real-escape-string.html
<1> !perror 111
<4> System error: 111 = Connection refused
<8> the MysticOne are you a Sufi?
<9> Using UPDATE, can I update more than one table?
<9> eg: UPDATE `inventory`, 'stocklevels'. Does that work?
<3> jbrimble: you can, check the update syntax in the manual
<9> !tell us about UPDATE
<4> But I don't know a thing about that.
<3> !man update
<4> (UPDATE Syntax) : http://dev.mysql.com/doc/mysql/en/UPDATE.html
<9> Thanks
<10> heu
<10> in a mysl master-salve replication setting i had to hard-reboot the slave. The replication got ****ed up after that, its trying to insert records that already exist.
<10> any way to fix this without recopying the entire db?
<10> shouldnt replication be able to withstand powerfailures?
<3> SunDevil: do a show slave status , you may be able to do something with the information there
<11> Hi there. :) Besides reconnecting, is there a way of resetting a client connection so that active transactions get rolled back and SQL variables go away?
<3> SunDevil: but note that power failuer could cause corruption to myisam tables
<11> Basically, I've got persistent connections in a PHP script, and am finding that open transactions are carrying over into successive hits on the script and causing all sorts of subtle breakage
<10> yes, but then you wouldnt expect duplicate entries
<3> nailbiter: disable the persistant connection then
<11> lokus: But that would mean taking a performance hit :-P
<3> nailbiter: not necessary
<3> mysql connection is pretty fast
<10> lokus: on multiple tables its trying to insert records that already exist. One table already has 60 records on top of the one the salve is trying to insert.
<12> hello all
<10> i am not completely sure if it's due to the powerfailure because the same say an application error also generated a few G's of queries
<3> SunDevil: maybe the slave is in the middle of the insert when the power failure occurs and some records are inserted but not complete yet
<10> *day
<11> We've benchmarked and found a 10-15% speed boost with persistent connections on; maybe it's because we have zillions of relatively small hits and don't actually do much processing
<10> lokus: then i would expect it to be a few records, but not 60
<3> SunDevil: check the last statement exected by the slave
<3> SunDevil: before and at the error occuring
<10> sec
<10> unzipping log
<11> Hrm, the 'RESET' statement doesn't actually reset transactions or SQL variables
<10> the error is a simple insert statement with NULL in an autoinc field. unfortunately this generated a duplicate key error
<3> SunDevil: the auto_inc cause a duplicate key error ? better check the table
<3> auto_inc with value NULL only cause duplicate key error when the max range of the datatype is reached
<10> mebbe the tableindex got corrupt during powerfailure?
<12> can me help with postfix why when i try to compile it this mysql support he write me error with mysql.h?
<3> possible, check table may show it
<10> already ran a repair, so cant check it anymore. will resync the repli and hope it never happens again :)
<12> dict_mysql.c:173:19: mysql.h: No such file or directory
<3> repair already and the insert still cause duplicate key error ?
<3> Antixrict: you need to have the mysql.h header file and maybe ave to set the correct include directory
<12> it's correct include directory
<1> ok this is starting to bother me now... can anyone help me figure out this error message?
<1> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
<1> I can't seem to give myself permissions to use my own mysql, even as root!
<3> !perror 111
<4> System error: 111 = Connection refused
<13> hi, what is wrong with this code ? (http://hashmysql.org/paste/1680) i think it's for old mysql version (i have mysql 5.0.9)
<3> what is the error message?
<3> maybe it is the zeros date time
<13> ERROR 1064 (42000) at line 273: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'schema ( vseq INT4 NOT NULL DEFAULT '0', ctime TIMESTAMP NOT NULL DEFAULT '' at line 1
<13> oh.. sorry..
<13> it isn't that error message..
<13> ERROR 1064 (42000) at line 268: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'schema ( vseq int(10) unsigned NOT NULL default '0', ctime datetime NOT NULL' at line 1
<14> qk: http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html
<15> i'm using two servers one master and one slave i'd like to make sure the slave is readonly
<15> how can i do this?
<3> there is an option either read or readonly, can't recall it
<1> http://pastebin.com/650921
<3> espresso: have you check it is running and listening to that socket?
<13> infi: i don't get it..
<3> qk: schema is a reserved word
<6> it shouldn't be a problem if properly quoted
<6> qk: try enclosing the schema like this `schema`
<13> Urgleflogue: it works! :)
<13> Thanks all!
<6> qk: enjoy
<6> qk: however it is not advisable to use reserved words unless you really know what you are doing
<16> could someone tell me how you can delete EVERY entry in a table but not the actual table without doing it dynamicalls - is there a function that will delete everything in a table without making you delete every individual entry
<6> mrtechguy: truncate table ?
<14> select `select` from `select` where `select` = 'select' and `and` like 'like';
<16> ?? explain please
<13> Urgleflogue: i must only correct this for "snortcenter"...
<14> mrtechguy: I was talking about something else
<16> ok
<6> mrtechguy: If I understand correctly, you want to wipe all of the records in a given table without dropping the table itself
<16> Urgleflogue: what would be the command for trucate table
<1> lokus: (jeez, I'm embarr***ed to ask)... how do I do that?
<3> espresso: ps and netstat
<3> espresso: requires some option though ps aux , not sure of what option required for netstat
<14> select `select` from `from` where `where` like 'like' and `and` is not in ('is','not','in');
<14> even uglier :)
<16> yes that is correct
<6> mrtechguy: truncate table <tablename>;
<16> does that work from php - tht my main question or would that be for ##php
<6> mrtechguy: it should.
<6> espresso: ps awx | grep mysql; netstat -nap | grep mysql
<16> thanks
<6> espresso: this will show you if your mysql daemon is working at all
<16> i have alway wondered what that meant it just seemed too dramatic - the sound of it - i thought it would kill something
<6> espresso: but my guesses are that it is not started, due some error
<1> Urgleflogue: this is friggin weird... right after I do a start, I did the ps, and it returned blank
<6> espresso: that's what I talk about
<6> espresso: you probably have some configuration errors, and your mysql daemon bails out at startup
<1> okay, so I've isolated that problem... now how to go about fixing it...
<1> you think perhaps a clean un-and-re-install would do the trick?
<6> espresso: usually first by figuring out what causes the daemon to exit
<6> espresso: no, I am against all unnecessary reinstals
<6> espresso: could you pastebin your my.cnf configuration file?
<6> or whatever it is called
<6> s/called/named/g
<1> have to find it
<6> try /etc
<6> or: locate my | grep ".cnf$"
<1> http://pastebin.com/650940
<1> it was in /etc
<17> can anybody point me in the right direction if I want to search through a database in a way that doesn't ****? (you know, not just doing "...WHERE text LIKE '%variable%'", but having something that allows you to search for multiple keywords)
<18> [jonne]: full text search ?
<19> [jonne], why don't you use the full text search?
<19> [jonne], it even offers boolean searches
<17> got a link for that?
<6> espresso: do you have /var/lib/mysql/mysql.sock file ?
<17> http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html
<20> I've got a user, 'user1' who has access from 3 machines, what is the easiest way to give that user grant option after he has already been created?
<17> never mind
<19> http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
<17> tnx
<1> Urgleflogue: yes
<1> and I haven't appended it...
<6> where is your database located?
Return to
#mysql
or
Go to some related
logs:
kdehiddenvisibility safe?
what is gam_serve
#mysql
onenigger
dbus_bus_acquire_service fc5
gothfunc
RHEL5 mptbase
gentoo coldplug blocks udev
gtkam in fc5
awk assign hostname to a variable
|
|