| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> you can select out the appropriate vars
<0> and calc them
<0> :)
<1> EyeCue: yeah.. i need a tool to calc
<0> nah you dont, just goto the health page docs
<0> they have the algo's there
<1> i don't have a network connection to the remote server via mysqld
<2> hey guys, i restored a table from backups using script command, but it looks like special characters that Word uses got messed up ..all instances of Words ' character are now s
<3> why on earth would you edit your backups with word?
<2> i didnt
<2> uses posted before, they copy paste and word has special characters for ' and quotes
<2> so now i have stuff like What risks does a foreign affiliate of a multinational firm face in todays in my database
<4> Hey, folks. I'm running into a time issue comparison issue. I'm trying to select records where the time (date_format(timefield, '%T')) is later than a given time, such as midnight (0:00:00). However, it seems to be failing on a comparison such as '02:00:00'>='0:00:00'. Is there some other way I should be comparing time values? (MySQL 4.0)
<2> shoot i think the backups are messed up
<5> i guess, that i have damaged mysql by replacing the root p***word...
<5> mysql --user=root mysql
<5> ERROR 1045: Access denied for user: 'root@localhost' (Using p***word: NO)
<6> mysql -uroot -p mysql
<5> but, always when i try to telnet zeus on 3306 it fails
<5> so my cacti database doesnt work
<5> i get this error: 05/25/2006 09:50:06 PM - CMDPHP: Poller[0] ERROR: Cannot connect to MySQL server on 'zeus'. Please make sure you have specified a valid MySQL database name in 'include/config.php'.
<7> ok I am trying to restore a myswl dump and it seems they hae used a reserved word for a table name, need to get up quickly as possible, anything that can be done?
<8> looking for a quick way to print mysql db tables (not the data, just the schema...)
<8> know of a good tool for this task?
<6> mysqldump -d
<8> thanks gleam_, though i'm looking for something more presentable.
<6> what's wrong with that?
<6> :P
<6> query information_schema
<9> Question: When mysql crashes, is there some sort of crash log it writes to?
<6> describe table
<6> it should write a reason to the error log
<9> would that include /var/log/syslog?
<9> Or should I be looking elsewhere?
<8> mysql administrator, phpmyadmin, and tools like those provide a nice presentation of table layout... but they don't have obvious print features.
<10> frank_farmer, it may, for exact location look in my.cnf
<9> phpmyadmin's print feature is at the bottom of the page
<8> frank_farmer, thanks, will check it out.
<11> is having two attributes within the same table reference one attribute in a different table as foreign keys illegal?
<12> it's pointless
<12> as they should then by definition have the same value
<12> unless you just mean across rows as well I guess
<12> should still work, pointless or not, iirc
<13> I need to temporarily disable the root p***word on my MySQL server. How do I do that?
<11> leith: well... how else would you handle a 'users' table and a 'messages' table... within the users table you have a recipient_id and a sender_id, which both point back to the users table as forign key constraints
<12> in those cases yes :)
<11> i mean within the messages table you have this
<10> !m titanium_platypu reset root
<14> titanium_platypu: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<12> Therion: I hate this theme with a p***ion
<13> wow....that looks easy to find
<11> cuz i got an error when i tried have recipient_id and sender_id both reference the user_id?
<15> Leith_: Which one?
<13> sorry, I don't know how I didn't find that
<13> thanks very much.
<12> that one you pointed at with coloured nicks
<12> it's on in this room
<16> can anyone tell me why this query is so slow? Explain: http://rafb.net/paste/results/VEQnvK49.html
<7> ok I am trying to restore a myswl dump and it seems they hae used a reserved word for a table name, need to get up quickly as possible, anything that can be done?
<15> Leith_: I hate the client, so hating the themes is just gravy.
<11> leith: can you tell me if you can do this?
<6> put backticks around the reserved words, mike.
<12> arooni: I said "yes" ;)
<12> dean: ahh I feel better now then
<15> Leith_: BANGERS AND MASH
<15> Leith_: I can't believe you haven't seen the Lost season 2 finale yet
<12> man it was lovely
<17> Hi!
<17> to store a number like 7 or 56, wich es better, int or mediumint ?
<15> Everyone talk about the finale now, stop talking about MySQL
<6> tinyint
<11> leith: ok, then why do i get the mysql error: Mysql::Error: Duplicate key name 'fk_users': alter table user_messages add constraint fk_users foreign key (recipient_id) references users(id)
<13> wait a minute....
<13> no, that shows how to CHANGE the p***word
<13> I want to remove it.
<12> dean: oh by the way I have a family emmergency
<12> dean: in oh, about 10 minutes
<17> newbie question: to store a number like 7 or 56, wich es better, int or mediumint ?
<13> would you just do SET P***WORD FOR 'root'@'localhost' = P***WORD('');
<13> ?
<12> arooni: you already have another foreign key called "fk_users"
<12> call it something else
<11> leith: is the name of the foreign key arbitrary?
<12> it's whatever you choose, yes
<18> hi
<12> call it "frank"
<18> oh yeh, "frank"
<18> nice one
<10> mikefoo check version the dump is for and edit the .sql is one way
<18> aaah, it's all so clear now
<15> And now... the end is near... and so I face the final curtain
<19> what kind of nick is that?
<15> A ***y nick
<15> It excites you just looking at it
<12> we should lick it
<15> mm licking
<19> 'dean' is a good solid nick, 'Iamtheoneandyour' makes no sense
<15> dean is a wussy nick
<15> Only a grrly boy would use it
<19> haha
<19> dean is an ice cream
<18> it actually says: Iamtheoneandyournot
<15> Iamtheoneandyour: In fact, it doesn't
<12> they were too dumb to notice the nick length
<19> no it doesn't
<19> hahaha
<18> but 'tis does noteth fiteth
<18> huhuhhuhuhahahah
<18> have you seen Gremlins: The return of Hippo II
<18> anyway
<13> so, I need to know how to temporarily REMOVE the root p***word
<13> not change it
<20> !m titanium_platypu reset root
<14> titanium_platypu: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<18> yeh that's wise
<10> hehe
<20> There are instructions on how to start MySQL without grant ta bles.
<18> good idea
<18> mmmmhmmm
<13> SQL, isn't that just for changing it?
<20> No
<10> its time SQL talked back
<14> I can't talk. I'm a BOT!
<10> add eliza to the bot
<20> I can't, I don't know who that is, etc.
<12> that would make SQL too un-goat-like for me
<12> Iamtheoneandyour: tough
<20> titanium_platypu, Read the section starting with "Alternatively, on any platform, you can set the new p***word using the mysql client(but this approach is less secure):"
<12> You are going to stay now
<18> Leith_ I'm just going to annoy everyone until I get kicked now
<18> OK
<15> !kick Iamtheoneandyour
<12> lol
<11> how would you folks model a system where: there is a user table and a messages table... a user sends & receives many messages. in the message table, there are attributes of recipient_id & sender_id that are foreign key references to the users.id ?
<15> Bummer
<12> :P
<18> hehehe
<21> lmao
<15> I'm officially pissed off about that now
<11> i mean i already know that there are two tables messages and users... but is anything else needed?
<11> like a mailbox?
<18> ooer
<11> that connects the two
<22> lol
<21> .......
<21> wow, SQL died.....
<20> !kickban mercestes
Return to
#mysql
or
Go to some related
logs:
#perl
Segmentation fault amsn 0.95
#ubuntu
gentoo intel drirc
#perl
locate lame ubuntu
ubuntu sound-juicer mp3 trouble
#mysql
innodb hotcopy
$_post value not recognised
|
|