| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> Is there a Linux GUI tool to visualize database design with relations? (like DBDesigner4)
<1> uh... DBDesigner4
<2> Darien : I pretty sure to have found my issue now - you were darned close with /proc/sys/fs/file-max - only I have a vServer and so the count there, doesn't matter at all - the limit, that counts comes from the Virtuozzo environment - /proc/user_beancounters tells me, that I have a ridiculous limit of 2240 open files - I don't know yet, if the MySQL crashes are related to that, but I'm pretty sure
<2> Darien : backups work now, that I shut down the ldap - crashed didn't occur any more - I'm following logs now to see about open-file-limit at the next crash - thanks a lot for your help!
<0> olinux: DBDesigner4 doesn't accept recent libmysqlclient
<1> dunno, maybe openoffice draw or freemind
<1> try sf.net?
<0> olinux: doing that already :)
<3> wow, I'm reading the list of people who use mysql
<3> and these are some big names
<4> why is this left join not working? "SELECT u.username FROM im_users u LEFT JOIN im_profiles i ON i.user_id = u.id WHERE u.id = 13"
<3> umm, why not select u.username from im_users where id=13 ?
<5> loef: Nothing wrong at all. But consider frb's suggestion.
<5> loef: Maybe you meant to use RIGHT JOIN or reverse the tables.
<3> sorry, it would be username, not u.username in my simplified query
<5> or INNER JOIN.
<6> ***ume I've made two fields UNIQUE, will that index be usable when querying by one of them fields
<5> EricCartman-iBoo: What index?
<5> EricCartman-iBoo: Each unique constraint provides an index that is usable.
<6> Xgc, unique as a group
<6> as in col1 and col2 cannot be same in two rows
<6> will that index be usable when filtering by col1
<5> EricCartman-iBoo: But often a compound index/constraint is often (in this case) useful for the first field, not the second.
<5> [col1, col2] is probably usable by col1.
<5> I suspect MySQL behaves this way. I don't know for sure. Oracle certinly does.
<5> certainly
<7> How to rebuild mysql database from scratch? I think I got into some problems (after installing MediaWiki!) and have lost access to my databases
<6> ok
<5> fantomas: You don't need to rebuild if you are only having problems with GRANTs.
<5> fantomas: Just rebuild the GRANTs.
<7> Xgc: how? I have no access
<7> Xgc: I can't even select * from users;
<5> fantomas: Look into the documentation for "resetting root p***word"
<7> Xgc: I remember p***word
<5> fantomas: No. A bad p***word is not going to help.
<5> fantomas: What did you mean when you said, "lost access to my databases"?
<7> Xgc: this means that 'root@localhost' is not DB SA anymore
<5> fantomas: Yes. That's a GRANT issue. Don't try to rebuild the entire database if that's the only problem.
<7> Xgc: ok
<5> fantomas: If you don't have root access and you should, you need to follow the "resetting root p***word" procedures ... or ask your DBA to fix it.
<7> Xgc: its mine machine where I'm root, so its not a problem
<7> Xgc: fixed, thanks!
<7> I think the reason was a record at the end of 'user' table: | localhost.localdomain | root | <pwd> | N | N | etc... all N-s
<7> (oops, in above message 'localhost.localdomain' should be replaced by 'localhost')
<8> my server became unresponsive, so I had to physically reboot it. I've managed to start MySQL, but none of my username/p***word combinations seem to grant access. I upgraded to 5 a few weeks ago and it would seem that I missed setting it up to run on boot. Any hints on where to go from here
<9> $sql4 = "UPDATE '$table[0]' SET '$column[0]'=CONVERT($current_charset'$row[$i]' USING $new_charset) LIMIT 1";
<9> is it possible to do something like this?
<9> (speaking of the query)
<9> is CONVERT a function that can be used in UPDATES too?
<5> Trixsey: Yes.
<9> Xgc: There is one thing I don't understand when I'm looking at MySQLs homepage
<9> SELECT CONVERT(_latin1'Mller' USING utf8);
<9> INSERT INTO utf8table (utf8column)
<9> SELECT CONVERT(latin1field USING utf8) FROM latin1table;
<9> they show me 2 queries
<9> in the first one they do _latin1
<9> oops
<9> in the first one they do _latin1'Mller'
<9> thats also the fieldname then?
<9> or is it _charset'field'
<9> UPDATE 'animania_animesummaries' SET 'aa_publisher_id'=CONVERT(aa_publisher_id USING utf8) LIMIT 1;
<9> I can't do this?
<5> Trixsey: No.
<5> Trixsey: 'aa_publisher_id' is not a valid column/field.
<9> oh
<9> it shouldnt be ' ' then
<5> Trixsey: aa_publisher_id
<5> Right.
<5> Some with the INSERT tablename
<5> Same
<9> hmm
<9> I ran the queries and nothing happened
<9> :/
<9> MySQL reports no error
<10> Hello, I am running Ubuntu and I've installed linux, it's apparently started, however, I can't connect to it from anywhere out side of localhost...? Help?
<10> Er, I've installed mysql***
<5> Prohibited: That's covered in the mysql documentation.
<5> Prohibited: Of course, you realize that there are other non-mysql reasons that could cause this behavior too, right?
<10> Xgc- Yeah, but I wouldn't see what... I have no router or anything ,and no firewall. So I don't know what other reasons that would be.
<10> I checked out the doc. What am I lookiing for exactly
<10> ?
<5> Prohibited: Look for the exact error you are seeing.
<10> not seeing any errors...?
<10> I just can't connect to the db out site of localhost
<5> Prohibited: Really? No error?
<10> And I thought I was supposed to get a 'save file' if mysql was running and I tried going to sitename.com:3306
<5> Prohibited: What?
<10> like for instance, if you go to a site like... www.eblah.com:3306 it comes up wwith a save file thing, my site is flameage.com, and when I try to go to flameage.com:3306 I can't access that :/ Mysql is apparentl;y running
<5> Prohibited: You might want to test with real MySQL client.
<10> hmm
<10> Maybe I should just try to reinstall :/
<5> Prohibited: What on earth are you doing?
<5> Prohibited: What client are you using for this test?
<10> telnet
<10> to try and connect
<5> Prohibited: Ok. and what does the telnet client tell you?
<10> Connecting To Flameage.com....Could not open connection to the host, on port 3306: Connect failed
<5> Prohibited: There are a fwe reasons for that. 1) Your server is not running. 2) Your server is not listening on that port (3306). ... there are others. I suspect 1 or 2 is your problem.
<5> Prohibited: These are all covered in the documentation.
<5> Prohibited: http://dev.mysql.com/doc/refman/4.1/en/can-not-connect-to-server.html
<5> Prohibited: That link covers these and other possible issues.
<10> error: 'Access denied for user: 'root@localhost' (Using p***word: NO)'
<10> How do I tell it what p***word I am using
<10> :|
<11> most people run it with the correct arguments. mysql -u user -p
<11> prohibited: I think you want a tutorial.
<11> !m prohibited tutorial
<12> prohibited: (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<13> hey guys.. anyone around to help with tuning mysql? i still get a horrible amount of iowait and I need to tune the mysql to use more memory and cache a lot more.. I have half a gig free on the server just sitting there. any ideas? i am using an example 'huge' config that is for systems with 1-2G of memory
<10> okay, those docs and tutorials aren't really helping, especially with mysqladmin... I tried netstat -ln | grep mysql --- here's what it said
<10> unix 2 [ ACC ] STREAM LISTENING 393447 /var/run/mysqld/mysqld.sock
<10> ..
<14> how to combine two mysql commands?
<15> haynes: be more specific pls.
<14> for ex; update users set favorite_number = -1
<14> where id = 4;
<14> where the value 4 has to be replaced by a value selected from another table
<11> haynes: what version of mysql?
<13> haynes, you could use UNION
<13> oh
<13> nevermind me
<14> 4.1
<11> good. you can use a subselect
<11> haynes: what is the source table and column of the id value?
<14> infi, is subselect a command
<11> no, it's a concept.
<11> update users set favorite_number = -1 where id = (select id from another_table where ...)
<14> infi, how is it implimented
<14> let me check
<14> infi, thanks
<16> hey
<16> i've been monitoring my newly installed mysql stats, and im finding something very strange
<16> max. concurrent connections --- ---
<16> Failed attempts .65 .13%
<16> Aborted .07 .00%
<17> spam!
<17> :P
<16> it seems to start with max concurrent connections at a very low number
<16> all my previous servers ive run have all been low
<16> (its a website using it, php)
<16> but then suddenly I check it, and there are loads of failed attempts
<16> the port is firewalled, i have no idea what could be causing this
<16> the site goes dead for about 4 minutes, cannot connect to the server, and it seems to coinside with this
<16> no idea what the hell is happening
<5> Prohibited: Yes. That's the problem. You're server is listening only to the local socket and not also to a port (3306 is the default).
<5> Your
<5> Prohibited: You probably have networking skipped. Check your config file.
<18> Hi every body. I have a very very urgent question for any mysql-guru.... Is any here?
<10> where is my config file
<10> :s
<5> Prohibited: That's covered in the document I posted to you.
Return to
#mysql
or
Go to some related
logs:
openmosix ubuntu
gentoo live cd or minimal
#perl
#qemu
ubuntu smp hyperthreading
gnome soundconverter mp3 greyed out
#web
Pyramid Zachman
burn daa linux
drw-rws---
|
|