| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> when using mysql_auth with apache 1.3 it works if the database is local to the apache server (localhost..etc..) But when i change the database host to be a remote host it fails, because it's looking for the field name "mysql_auth" in my database table. I have specifically told it too look for "users" table, but it ignores that. It does this only when connecting to a remote databse host.
<1> salle: very cool page
<0> correct....it looks for the table_name "mysql_auth"
<2> may not have perms to run that on the other hosts db
<0> Iontas, the account has been tested that I can login from my apache host, to mysql with necessary privleges
<3> salle - that query will do a tablescan
<3> Iontas, salle - just do two queries/ a subquery
<4> Iontas: Here is the subuery syntax which may look simpler to you: SELECT (SELECT COUNT(*) FROM tbl WHERE col=x) / (SELECT COUNT(*) FROM tbl);
<3> it'll be much faster as well
<4> sjrussel: Maybe yes, maybe not :)
<3> only not if col is not index or has very low cardiniality
<4> sjrussel: But you can do much more with such IF()s
<4> sjrussel: ... or the WHERE condition matches too many rows
<3> right, low cardinialty
<3> but it would probably still be faster, index scan vs. tablescan
<5> hi all
<5> I am sure this has been asked before, but i am unable to use mysql -p
<5> I know it is something with mysqlqccess.conf (it's the default SuSE one)
<5> I'm able to skip the -p, and log in as root (!), but as a user, it complains about the -p and then complains that I didn't give a p***word
<5> it's tied in somehow to real users on my system, instead of db users
<6> have you tried just setting p***word for your users in the db?
<7> hi
<5> yes the user has a p***word
<5> hmm maybe root does not
<5> ERROR 1045 (28000): Access denied for user 'greylist'@'localhost' (using p***word: YES)
<5> that db user does have a p***word
<6> have you tried resetting it? :)
<5> I just set it not 5 minutes ago
<5> grant all on greylist to 'greylist' identified by '...';
<5> when I ran 'mysql' as root and it let me log in without a p***word :P
<6> did you use P***WORD('myp***') when you set it? if so, well i'm out of ideas.
<6> it does on a fresh install, afaik.
<6> misty: you might want to try grant all on greylist to 'greylist'@'localhost' as apposed to just greylist
<5> ok
<8> Can I ask someone a quick emergency MySQL support question?
<9> lietz: ask away
<5> yeds that worked
<8> I've got MySQL 4.1.10a running on a CentOS linux box. I just ran REPAIR TABLE (tbl_name) on a table that was reporting #1016 - Can't open file: 'files_index.MYI' (errno: 144)
<10> lietz: that is bad.
<8> That was about a half hour ago. The repair appears to still be running, but the server is now behaving strangely. How long should a repair like this take, and is there any way to check the status? phpMyAdmin reports that the table is "in use"
<10> 144 is table crashed repair failed
<11> How big is the table and its indexes?
<8> taking a look
<8> I'm having a hard time getting in to find that information- the MySQL server is crawling, and I can't even SSH in now.
<8> It's a fairly large table, but not gargantuan. It's a file index- and probably has a few thousand rows.
<9> well myi is not that critical
<9> its the index file ..
<8> Should I try to restart the server then, and look to do some kind of a reconstruction of the index file?
<10> lsmith: shouldn't the repair table have been able to rebuild the index file?
<9> i would have expected it to
<9> might imply there are worse things to come
<8> I can't wait
<6> misty: cool
<10> lietz: stop database, do myisamchk -r tablename
<8> johann: thanks, I'll give that a try.
<10> that should rebuild the index
<10> maybe a copy before, though :-)
<8> Alright, bad news. Couldn't SSH, so went to the keyboard. Terminal is scrolling with file system errors.
<12> I want to query a table that reports xx1 and xx2 and xx3 and xx4 and xxx9, and select * from service where d01 like 'xx' does not work?
<13> is there a way to clean out my innodb tablespace?
<13> there seem to be references to databases that no longer exist
<11> cdavis: You mean "like 'xx%'", I think.
<8> johann/lsmith: "EXT3-fs error (device dm-o) in start_transaction: Journal has aborted" This has obviously moved beyond a MySQL problem- but can I ask, does anyone have any advice on how I can shut this down now without completely corrupting the database / filesystem?
<9> sorry .. i am not much of an admin :-/
<9> do you have mysql support?
<12> mendel, thanks, how would I do it if I also wanted to show 5xx 1xx 33xx? select * where d01 like "xx%" and like "%xx"
<9> this might be the time to use one of your support tickets
<11> "%xx%" -- note that won't use any indexes
<8> lsmith: No, unfortunately we don't. This may mean we try to restore from one of our nightly dumps. If we do need some additional MySQL support to get this stuff up and running, any advice on good resources?
<12> mendel, is % like * to linux? And would ?xx report 1xx 2xx 3xx and not 11xx 22xx 33xx?
<11> "*" isn't anything to linux, but it's a wildcard, yes, and no, "?" isn't anything
<14> Is there a way to manually increase the next auto_increment id to be used for a table? I'm trying to work around http://bugs.mysql.com/bug.php?id=2027
<3> alter table
<15> Is it expected that a where condition WHERE integercolumn = 'somemistakestring' works as a true condition, rather than producing an error?
<3> lietz - to stop a repair, you have to kill the database server
<11> rey: Why would that produce an error?
<11> Oh, I see what you mean.
<11> I believe it strips out the non-digity parts. Let me check.
<15> I made a mistake on columns and ended up nuking an entire table that way (had a backup of course ;))
<11> Ah, no, it strips *trailing* non-digity parts.
<15> column of integer values and I did WHERE col = 'username'
<15> no digits anywhere in that
<11> select thing from otherthing where intcolumn = '1foo'; -- selects where intcolumn = 1
<14> sjrussel, Do you think changing the next id would be a workaround for the bug I linked to?
<15> mendel: I had no integer in the string but this was for an update if that makes a difference
<11> reywob: It either doesn't match anything or it matches NULL
<11> Just like intcolumn = ''
<8> sjrussel: thank you. I ended up just having to reboot the box- I couldn't SSH or get a local command line.
<16> I'm on FC3, what's the command to startup mysqld?
<3> jojo - sounds like a corrupted table to me
<14> sjrussel, MySQL version is 3.23
<11> element: /etc/init.d/mysql start (or maybe "mysqld")
<8> johann: The server is at least back up and stable. The corrupted table is still reporting "in use" in phpMyAdmin, but at least the other tables and databases are accessible now. I'll give myisamchk -r tablename a try tonight, when I'll disrupt fewer people.
<8> Thanks everyone for your help.
<3> jojo - I doubt that matters , have you tried repair table?
<16> mendel: that did it, thanks!
<3> lietz - good luck recovering your data
<3> are you binlogging
<8> sjrussel: thank you
<10> lietz: i'd make a copy of the myd and the frm file
<8> johann: alright, thank you. Appreciate your help.
<17> I just install mysql server 5 on a Fedora 4 box and I am getting timeout errors when trying to start it
<17> The logs don't say much so I am at a loss
<17> I installed it on an exact box with no problems.
<18> Puzzled: why doesn't this work..? http://pastebin.com/548596
<18> That is, I'm puzzled. It wasn't a query for Puzzled to answer.
<19> isn't = case insensitive?
<20> I have a "list" I want to delete. In another table, there are rows that reference the "list" id... I can delete those fine enough. How can I delete from a third table, which references the second table, who references the first?
<18> fsweetser: oh, for crying out loud, how do I get a case-sensitive search?
<21> strib: BINARY
<18> Thanks
<18> I can set this somehow, can I?
<18> It's the collation type?
<21> or binary in a query string
<18> I've done binary(t1.alias) for now; is there a better way?
<21> setting the collation is more appropriate if you always want it to be case sensitive. Often, binary is enough for the odd query that requires it
<18> inviso: yeah, this is to construct apache configs so it's ascii really
<18> I'll alter the table
<1> how is LIKE '%???%' working but REGEXP '[[:<:]]\\?\\?\\?' is not?
<1> i'm searching for the word '???'
<21> fulld: like '%???%' is horrible for performance. Use full text search
<21> !man regex
<22> (MySQL Regular Expressions) : http://dev.mysql.com/doc/mysql/en/Regexp.html
<18> inviso: erm.. it's a BLOB. Somewhat surprising that _B_LOBs have a character type
<21> strib: blob is binary. binary searching by default, iirc
<1> inviso: that's why i switching but i guess i'm escaping wrong
<21> and, obviously, it shouldn't be a blob
<21> fulld: regexp is rather slow as well. Neither get to use any indexes you might have created
<1> inviso: i came here earlier and concluded that fulltext is not an option
<21> fulld: and was is the growth on the beginning of the regex?
<1> old way was: %ed% %chris% %bob%
<1> now it is REGEX '[[:<:]]ed' '[[:<:]]chris'
<1> but this fails when i'm looking for three question marks
<23> [Regarding mysql configuration on Debian] I upgraded mysql4 (from repositories) to mysql5 (compiled it myself) on a Ubuntu Breezy system. The reason for this is that an application I use needs version 5, and I certainly need this app. Anyway, I've got some programs that use msql such as amaroK (an audio player for kde). This app lets me specify hostname, port, database, user, p***word but it complains that /var/run/mysqld.socket is not fo
<1> can I do something like REGEX concat('[[:<:]]', REGEX_ESCAPE('ed'))
<1> so that ed is treated like a real string, not a regex
<21> fulld: [[:<:]]ed is not even close to the same as %ed%. It's the same as ed%
<24> that looks like a very square smiley
<21> I found "growth" to be an appropriate term for it
<1> inviso: that's intentional, i'm just worried about the regex breaking with ?
<25> does mysql support check? ie create table t ( ... x check (x > 10) ) ?
<21> fulld: ? is a special character in regexp. Try [?]
<21> fulld: actually, \? should work
<21> fulld: bah, it apparently needs two.. \\?
<1> aah
<1> also the word boundry was a problem
<1> '([[:<:]]|[:blank:])[?][?][?]' works
<1> i guess '(^|[:blank:])[?][?][?]' works
<26> I want to SUM two fields from different tables. There are not an equal number of rows in each table, and I can't use a subquery. Is this possible to do? Any type of join will force an equal number of rows before it starts summing right?
<27> looking at a design problem where im storing many records of blobs some up to 250KB, but most in the < 10K. any ideas how to set it up?
Return to
#mysql
or
Go to some related
logs:
fglrx located with port 80
how to fix xorg.config in text mode
pilot xfer segmentation fault ubuntu
ati 3D RAGE iic xubuntu
#ubuntu
christina perlvar
bran's kernel development
paste.debian.org
#gentoo
#perl
|
|