| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> seems my only option is to get the src rpm, and build it myself
<0> anyone happen to have a repository of rpms mysql.com rpms lying around?
<1> unlikely
<2> syah maybe in one of those dusty cd's given by computers magazines
<0> hrmmm
<3> can you not just look on the repository ?
<3> i forget the name of it :P
<3> is a long time since i used an rpm based distro :S
<1> good
<1> they **** :/
<4> with MySQL 5, is there a way to determine the currently logged in user of a session?
<5> I could use some help : when I installed I followed a help guide that showed an example of on config to do -with-unix-socket-path=/tmp/mysql.socket; now I don't have the mysqld.sock file .
<5> are these related
<5> I have looked all over the place for the socket file
<5> but can't find it on my local system
<6> Help to the please... dev.mysql.com i've digging the site but i cannot find any example how to use 'Temporary Table'
<6> http://dev.mysql.com/doc/refman/4.1/en/temporary-table-problems.html they put <blue> to the TEMPORARY Keyword, but they dont put Link to it :(
<6> Thanks to Google [Im Feeling Lucky] .... its more better than dev.mysql.com search
<7> "more better"?
<6> Goplat, try: "MySQL Temporary Table" + Im Feeling Lucky
<6> compare to the dev.mysql.com
<8> after installing mysql 5.0.18 by mistake I deleted the anonymous user, how can i fix this up?
<9> hi guys
<8> hello
<8> After installing mysql 5.0.18 by mistake I deleted the mysql anonymous user, how can i fix this up? Please help
<9> vr_mex: useradd -g mysql -d /var/lib/mysql mysql may work
<8> Psykick, thanks, tell me what happens if the anonymous user is deleted?
<9> most likely the mysql service won't start and there will be permission errors since the user no longer exists
<9> one other thing I can think of to check
<9> have a look at the data directory for mysql and do an ls -l (linux) and see if where the username would normally appear if there is now a number
<9> if there is a number .... change the useradd statement to: useradd -g mysql -u <number from ls> -d /var/lib/mysql mysql
<8> Psykick, ok let me check all this...
<10> hey.. does posting a bug saying mysql 5.1 is slow as a pig on solaris qualify for the contest?
<9> hmmm
<9> not sure on that one sam
<11> Why do you want an anonymous user?
<11> !m Psykick adding new user
<12> Psykick: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<9> will: I didn't want to know how to create anonymous user
<9> will: check again
<11> Fix what?
<10> Psykick: not sure? i'm getting solaris being a order of magnitude slower
<11> You said fix it....
<11> oh
<8> After installing mysql 5.0.18 by mistake I deleted the mysql anonymous user, how can i fix this up? Please help
<11> vr_mex :P
<11> !m vr_mex adding new user
<12> vr_mex: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<11> Psykick, Plus, that is not the "anonymous" user.
<9> will: I'm ***uming he deleted the mysql unix user account not the db one
<8> I deleted the db one, please help
<11> !m vr_mex adding new user
<12> vr_mex: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<11> Read it.
<11> Or shut it.
<13> Can someone tell me why I would be getting an error with this "mysql_query("INSERT INTO log(usrid, item, paid) VALUES('$playerid', '$item', '$points') ")or die(mysql_error());"
<9> vr_mex: read the link given
<11> What is the error.
<13> 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 'log(usrid, item, paid) VALUES('1', '86', '300')' at line 1
<11> !m zushiba reserved words
<12> zushiba: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<8> Psykick, ok
<10> !m solaris
<12> Incorrect usage. See 'help m'
<10> !m firemansam solaris
<12> firemansam: (Solaris Notes) : http://dev.mysql.com/doc/mysql/en/Solaris.html
<12> Solaris ****s big harry moose verbosis!
<9> zushiba: escape from the single quotes eg: "mysql_query("INSERT INTO log(usrid, item, paid) VALUES('" . $playerid . "', '" . $item . "', '$points') ")or die(mysql_error());"
<13> Okay, I'm not seeing the problem.
<9> zushiba: escape from the single quotes eg: "mysql_query("INSERT INTO log(usrid, item, paid) VALUES('" . $playerid . "', '" . $item . "', '" . $points . "') ")or die(mysql_error());"
<13> hmm
<11> Psykick, No
<14> Psykick: Bzzzzt! But thanks for playing.
<11> The error tells you where the error is...
<13> : / it works fine with another script.
<10> hmm.. does the SQL bot have any other cute comments?
<11> No
<11> [RainMkr], You got this one ? :)
<14> will: not on your worst day.
<9> if its PHP which I'm sure it is ... the values aren't being evaluated
<11> It's a MySQL error. As was pasted.
<13> so.. the name of the table log is the issue or what, cause its not on this list of reserved words, neither is item, paid or usrid..
<14> !m zushiba reserved words
<12> zushiba: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<13> yeah, thats awesome...
<11> Log isn't?
<14> *boggle*
<13> Its not on that list.
<13> LOAD LOCALTIME LOCALTIMESTAMP LOCK LONG LONGBLOB LONGTEXT LOOP LOW_PRIORITY
<14> will: Interestingly neither is, SIN, COS, TAN...
<11> heh
<11> Guessing that those would have () so that's how it could tell...
<11> zushiba, $query = "INSERT INTO log(...."; mysql_query( $query ) or die( $query . mysql_error() );
<11> Change your PHP to do that.
<13> Actually I changed from that to what I pasted to make it as simple as possible.
<13> $updatelog = "INSERT INTO log(usrid, item, paid) VALUES('$playerid', '$item', '$points') ";
<13> mysql_query($updatelog) or die('Error, query failed');
<11> CHange the die() to match mine. Paste that.
<13> sec
<11> ***
<11> hehe
<11> CREATE TABLE `SQL_CALC_FOUND_ROWS` ( ....
<13> 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 'log(usrid, item, paid) VALUES('1', '86', '300')' at line 1
<11> Paste the query too.
<11> Seriously not listening...
<13> it is, didn't paste it.
<11> Well... why not?
<13> unknown
<13> otherwise I would paste it :P
<11> How about you paste it...
<13> I would but changing the table name to lootlog actually fixed it.
<11> What version are you running?
<13> 4.0.25
<14> o/` Open the door, get on the floor. Everyone do the dinosaur! o/`
<11> I guess no one has ever tried to name their table "log"
<13> lol ok.
<11> I love when game demos are 500MB..
<15> I can insert/select using mysql_real_query ... however, where can I find the C interface for mysql for dealing with BLOBs ?
<16> woah
<16> mysql_real_query? php?
<15> no
<15> C
<15> I'm using C
<15> to insert doubles/ints into a table; I can do mysql_real_query("insert into blah values (.....)"; this does not work when one of the values I need to insert is a BLOB; how do I deal with that?
<5> After installing Mysql 5.1 I find I haven't /var/run/mysqld/mysqld.sock where did I go wrong?
<3> did you start the daemon ?
<16> _intel: you didn't start it...
<16> or you disabled socket in my.ini
<5> in the config I told it to use unix sockets
<17> Is there a DATE() function in mysql ... I can't seem to track it down on the web. So far I've only gotten NOW() ... I just want a date as in 2006-4-4 ... or something in that format
<17> roughly
<9> hi guys
<11> babo, CURDATE()
<17> will : cool thanks ...
<18> evening / morning all
<11> Howdy
<18> I'm seeking advice, on performing searches across a document index. Trying to balance relevance with performance. Any tips appreciated :-)
<14> MrCraig: Use MyISAM tables and fulltext index(es)
<11> I'm surprised you'd recommend FTI :)
<11> I thought everyone hated it. Or maybe that's just Therion.
<18> I was supprised too - I've been looking at tokenized models.
<11> damn_I_am_good...
<18> With tokenizing I could do additional searches for fx: when the search term contains the word cat it'll also search feline.
<11> FullText has something similar.
<11> If data is present.
<19> can anyone help?
<11> Nope
<11> It's forbidden in this channel.
<19> :P
<19> I'm stuck with a left join problem
<19> can anyone help?
Return to
#mysql
or
Go to some related
logs:
SDL: Initializing of SDL failed: No available video device.
#web
phpmyadmin cnahge charset
#css
#math
mindamp
#gentoo
#centos
#sdl
#perl
|
|