| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> tziku: you should install the server probably
<0> GaryKing: add it to your path
<1> Darien: Yeah, I don't quite get that. I think I did before, and it was working. Not anymore.
<0> ok
<1> I added it to .bash_profile I think and it was working at one point
<2> Darien i have that problem when i'm trying to install mysql-server (apt-get install mysql-server)
<0> GaryKing: add it to .profile
<1> Darien: ah. interesting. then what is .bash_profile?
<0> GaryKing: same thing, but only for bash
<0> as opposed to for any bourne-compatible shell
<1> Darien: erm should work then..
<1> because I'm using Terminal aka bash
<0> yeah, but I think it doesn't
<1> ok
<1> interesting. I think I got it. by jove!
<1> (again, that is)
<0> k super
<1> Feels like such an accomplishment when you achieve something in UNIX :P
<3> lol
<3> ewe-knicks
<3> lee-knucks
<3> I heard a guy came in my shop talkin to me about php/msql sh!7 and he says "yeah I use my sequal ...."
<3> so I hit him about the neck and shoulders for about 12 minutes
<0> good man
<0> we usually recommend a baton or tire iron
<3> all I had was a ball-peen hammer
<0> that should work
<4> Key_read_requests 01817
<4> Key_reads 574
<4> is this still healthy ?
<5> yeah
<4> k thx
<6> Is there anyway to use soundex() in a full text (bool) search?
<5> not really
<7> how can I define links between two different rows on the same table? Like if I have a users table and I want users in the table to have friends in a two way sort of relationship and also different users should be allowed to have lots of friends
<8> hi. does mysql have any issues with windows 64 bit?
<6> So how would you recommend building a googlesque spell checker for searches?
<9> if I have a database with fields ID (primary key) and username, is it possible to configure MySQL to not accept the same username for 2 entries?
<6> we have lots of proper nouns, so we'd want to do a sounds like on the full text index?
<10> kavelot: make username a primary key?
<9> but if I make (id,username) primary key, it would allow 1-userA 2-userB
<9> sorry
<9> 1-userA 2-userA
<3> either that or do a select count (*) from myTable where myName="name";
<3> if that returns zero
<3> yer gudtago
<10> kavelot: dont make a primary key of the id and the username, make a primary for the id and a primary key for the username
<9> hm
<9> didn't know it was allowed
<3> to keys?
<3> tw0?
<3> I like my idea better
<3> select count (*) from myTable where myName="name";
<5> make a primary key for the id and a unique key for the username
<10> kavelot: you'll never be able to insert the same username twice...
<5> you can't have two primary keys
<10> firewire: you are correct, that's what I meant
<3> huh?
<3> lol
<11> i have a fresh install of debian and installed mysql from repo... i added an xplanner database and used "grant all on xplanner.* to 'xplanner'@'%' identified by 'foobar';" and yet I can't connect to it from my other machine, the other machine spits out "ERROR 2003: Can't connect to mysql server on '192.168.250.4' (111)", any ideas?
<5> yeah
<5> mysqld isn't running
<11> i can connect to it locally though
<11> erm
<3> fire wall?
<5> do you have a bind-address line in my.cnf?
<11> my.conf is stock- so i don't know
<9> now it works, thanks :D
<11> there are a number of mysqld processes (ps aux|grep mysqld) and my firewall, as it were, is currently nothing more than "-A INPUT -j ACCEPT"
<10> SoNikU: Try to add a grant all to xplanner@ip-address and see if that works.. if it does, then you know it is not the firewall..
<11> heh, so "bind-address = 127.0.0.1" is bad then?
<9> is it possible to do a "simulated INSERT", just to check if it will give errors, but without inserting in case no errors happen
<10> <soniku> did you also flush privileges?
<11> jollygood: yes.
<12> how do i create a user and p***word in mysql
<12> from console
<10> <soniku> maybe your router does not p*** traffic from one computer to the next?
<13> oi-polloi: Use the mysql command line client and GRANT command.
<12> i looked at one lot lot of info and it didnt work
<12> using the grant command
<11> jollygood: same network segment, no router in-between
<13> oi-polloi: With MySQL 5.0 there are other alternatives... but GRANT will do it. Just follow the examples in the docs.
<11> "mysql -h 192.168.250.4 -u xplanner -p xplanner" is the appropriate command, no?
<11> the user and database are both "xplanner" btw
<14> someone please help me, im getting this error: ERROR 1030 (HY000): Got error 127 from storage engine
<10> <soniku>well you typed foobar for the pasword on your post above...
<10> <soniku> is the p***word foobar or xplanner?
<11> yes- and when it prompts for the p***word, that's what I enter
<11> the last xplanner isn't the p***word...
<10> <soniku> tryp mysql -h192.158.250.4 -uxplanner -pxplanner (notice no spaces between u and xplanner and p and xplanner)
<10> <soniku> if you use the -p on the command line it should not ask you for a p***word
<10> <soniku> and if the p***word is indeed foobar then you will need:
<10> <soniku> mysql -h192.158.250.4 -uxplanner -pfoobar
<11> supplying a p***word with the p switch is optional, without the switch it tries to connect with no p***word
<11> but i didn't want to supply the p***word on the command line
<10> <soniku> then mysql -h192.158.250.4 -uxplanner -p
<10> <soniku> then type the p***word
<11> same error
<10> <soniku> sorry
<11> hmm, i justed poked port 3306 with telnet and it refused the connection
<11> well, thanks guys, i'm going to kick iptables around a bit- it's probably a problem there
<15> How do I convert a former slave to a master?
<8> no one has any idea?
<16> Hey.. I have issues with when I do normal SELECT * FROM db WHERE column1 = 'Something Goes Here' ORDER BY date LIMIT 1 stalling up my machine entirely, It might take 2-3 minutes for it to actually return the data, and this is only in maybe 1 out of 20-30 searches
<16> I'm not quite sure how to work this out :S
<16> When it happens, I hear a lot of working on the disk, and I check with mysql administrator and its stuck at 'Sorting' under State
<10> <jay> have you got a key setup for column1?
<14> MySQL error: 127 = Record-file is crashed
<14> how do you fix this
<14> ERROR 1030 (HY000): Got error 127 from storage engine
<16> Yes, column1 is primary key, and I have a normal 'index' that includes 5 out of the 8 columns, including 'date'
<5> 5 columns in an index?
<16> yes :S
<5> show us the explain output for that query
<16> !man syntax explain
<17> (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<5> put the word 'explain' before select
<10> <command> have you tried to run a REPAIR TABLE?
<10> <jay> how much ram do you have?
<5> jollygood one step at a time
<10> firewire: I see your post, did not mean to step on your toesees
<14> jollygood: worked, thanks
<16> 1SIMPLEalbumnamerefPRIMARY,SEARCHPRIMARYconstUsing where; Using filesort
<16> jollygood - I think about 512
<6> How can I make a wildcard string compar with soundex? i.e. WHERE SOUNDEX(col) like %SOUNDEX("str")%
<10> <command> super
<6> obviously this doens't work
<6> but how do I add the wild cards?
<10> <jay>how many colums is your query returning if you were not using limit 1?
<16> 1 also
<16> since albumname is primary key, no 'dupes'
<16> could it be a simple matter of resource shortage? its a 900mhz CPU with a constant load of 50-70%
<10> <jay>why are you sorting if you only get one record?
<16> That is a good question, so if I stopped the sorting it might not happen in these searches, but if I begin to do searches with wildcards, with several columns, I might end up with the same problems wont I?
<10> <jay> try it without the order by...
<5> search primary?
<16> Search is just the index name I gave the index that covers all the columns I use in WHERE statements
<16> figured that gave the most sense :S
<5> do you have an index with column1 and date?
<16> yes
<5> pastebin show create table db
<16> firewire - I get incorrect syntax with that.. used show create albuminfo artist_db
<18> I have three tables that are the same with regard to the typs od fileds they have, and I want to select the same row/column cell and add the the three together to input into a totals table.
<16> !man show syntax
<17> (SHOW Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW.html
<16> gotcha.
<18> well, I've looked at sum() and a few other things and i've confused
<10> <18> what have you tried?
<18> I haven't try any thing yet
<18> not sure how to write the query
<10> <18>are you just adding the total of a field on each table, then adding each of the total together again?
Return to
#mysql
or
Go to some related
logs:
ubuntu xine-win32
sbcl run-program cat
get around sonicwall tor
centos memtestx86
totem dpkg-reconfigure blue screen
glxgears fc5 choppy
#python
centos+gnone install
#linux
NamedTemporaryFile recipe
|
|