Sawyer: I was saying the p****r was stupid, but good thought. :

Fonua: Turns out it gets confused if you use a reserved word as a table alias. So actually that’s pretty reasonable.

Nave: If you call your inner query ‘inner’ it’s like ‘inner group by? Wha?’

Nafziger: Should I be basing my schema on this https://en.wikipedia.org/wiki/Data_Vault_Modeling

Swerdlow: Because it says it’s a db design intented to provide long term historical data

Redhead: While in my case social network, most data is what the call ‘hot data’ which is basically recent events. Evrything one month old is pretty rarely seen.

Varieur: JFlash: I’m not sure you should separate the concept of ‘event’ and ‘comment’

Brener: Do you mean I should store each and evry action on the site in a single big table?

Varieur: JFlash: no, but an event is not a comment.

Hopp: A comment is an event in on the site that will end up on ppls timelines

Varieur: If a comment is an event, what else is an event?

Varieur: Also, is this social network a real public project, and if so, what will be its name?

Culton: I’m open to calling it ThumbsNet if you keep helping me out, y’ve been great

Varieur: I was planning on avoiding it, actually.

Schlink: An event is evrything can end up in ppls newsfeeds

Varieur: Well, ‘event’ can have attendees – so I don’t think it should be the same thing as a comment.

Zomer: Like in . ‘mary is attending a conference near your today’. or ‘ Justin Bieber just updated his profile photo”

Comissiong: No it’s not an event in the sense that ppl attent to it. event as in action

Clemon: And before you ask, no, I’m not 15 and I’m not a fan 😀

Paschal: I need help in mysql on debian

Hokkanen: I’m getting this error creating a mail server database

Strelow: You probably have a wrong p***word in /root/.my.cnf

Varieur: Asterismo: provide the correct root p***word.

Liukkonen: Or some other configuration file

Nockai: You need to specify the p***word. use the -p option to mysql

Varieur: Danblack: using. YES means that he provided it.

Majmundar: True. mind elsewhere. better focus there :-

Messerly: I’ll better get my pendulum, I feel a p***word recovery coming

Hnat: Asterismo: Stop the mysqld server, add ‘skip-grant-tables=1’ to my.cnf under mysqld, start the mysqld server, connect using ‘mysql -u root’ and do ‘use mysql;’ then do ‘UPDATE user SET P***word = P***WORD’new_pwd’ WHERE User = ‘root’ AND Host=’localhost’;’, clean up my.cnf and restart the mysqld server, test with ‘mysql -u root -p’ by entering your new p***word at the prompt. threnody

Raisin: Varieur: what do u mean by “clean up my.cnf”?

Varieur: Asterismo: remove what you added just before.

Roles: How do i quit mysql prompt?

Benezra: Asterismo: The enter key or return key is not a substitute for punctuation. Use a period ‘.’, comma ‘,’, colon ‘:’, semi-colon ‘;’ emdash’–‘, or elipsis ‘.’ instead. In other words: DON’T HIT ENTER UNTIL YOU’RE DONE.

Anast: It’s all good bruh, happy labor day.

Thorpe: Asterismo, don’t be alarmed by the bot

Luttman: No, totally fine, i get that in other channels as well

Rangel: I’m trying to change it, but it is hard

Campoverde: No worries, happy labor day if you are working cl*** ;

Varieur: Oh, I agree. Easy on the enter key.

Raupp: This is a stupid question, but how do I turn off mysql on a windows 7 developer laptop

Varieur: Buddd: depend on how it was installed / started

Gutteridge: I am trying all these commands in both the windows command prompt and the mysql command prompt and nothing is happening except error messages

Goleman: I did everything by the book