| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> i'll probably have to do one column for day of week
<0> and one column for open and one for close
<1> LunchStartTime, LunchEndTime, DinnerStartTime, DinnerEndTime
<0> and for monday, have to have 2 rows
<1> yuppers
<1> you could do it that way
<1> it really depends on how you want to use the data
<0> because it might only be mondays that are only open blank to blank
<0> other days they might not closse after lunch
<0> i'm building a tool for myself to find open restaurants
<1> ah in that case you are much better off with your design
<0> using googlemaps
<1> heh
<0> because i can never remember what is open when
<0> i would rather have a website tell me what is open and where
<1> i use the technique of just going out and wandering around until i find somewhere that looks promising :P
<0> rather then guess, and check 20 different websites, one for each restaurant
<0> yes, but in that time, some might close
<0> if you had gone to the open one first, you could have gotten in
<1> well if they close that makes the problem simpler to solve :D
<0> there are other restaurants then dennys
<0> fyi
<1> dennys ?
<0> denny's
<1> who is denny ?
<0> its a 24/7 dinner in the states
<0> i take it you are not american
<1> LOL
<1> i would hardly call that a restaurant
<1> no i am not :P
<0> hell, around here, not even jack in the box is always open
<1> i do not know what is jack in the box either
<0> fast food places that close really piss me off
<1> in my old town, the shops that stayed open really late closed at 8pm :P
<0> driving up to it, just to find out it closed 10 minutes ago at 12:30am when i lift the house
<1> and there were two of them :P
<0> ****
<1> oh i loved it there
<0> i don't even wake up till 4pm some days
<1> is not like i can't cook :P
<0> i should probably make DayOfWeek an enum
<0> for speed
<2> hi, how do I activate the logging of all the queries in mysql installed in a linux box?, thanks
<3> ug
<3> look at the my.cnf or ini file
<3> but make sureyou turn it off after
<2> NET||abuse, I dont find anything regarding logging in my.conf
<3> juanma, one sec i'll look
<4> I wonder whether to use one-column or multi-column indexes (InnoDB VARCHAR). I mailny use 3 search queries, if i use multicolumn indexes i would have to change them whenever search query is changed much. Would SELECT using one-column indexes be much slower?
<3> juanma, yeh, i'm only seeing innodb log references in the ini..
<3> hmm, i was certain there was a way to turn on query logging
<3> i've never done it myself however
<5> morning, good
<5> i have a problem with errornous tables:
<5> table has en error: Incorrect information in file: './mydatabase/Art.frm'
<5> what can i do?=
<6> check table
<6> you have a backup?
<7> Hey Can I have mysql running on port 3306 and have another mysql installed on port 3315 and run both the services at the same time?
<8> yes
<7> domas: thanks
<9> I cannot start my MySQL server, my error message is;
<9> 060529 11:26:03 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
<9> does anyone have any idea about that?
<10> sounds like your mysql db is borked.
<1> i had that the other day
<1> turned out my hard disk was full
<9> Yeah, I have a very full disk
<1> no idea why it produced that particular error though
<9> that has been a problem recently
<1> i just deleted 6GB of junk and away i went :P
<9> I would like to do the same thing
<9> but the /var/ partition
<9> was built with only 2 Gigs!
<9> so I cannot
<9> can I symlink the db?
<1> sure
<4> What is fefault lenght of INDEX set on VARCHAR column?
<4> *default?
<8> depends on length of varchar column, I guess
<4> Show create table doesn;t show that lenght
<4> how can i check it?
<4> I haven;t fount info in the docs
<8> it's same as field length
<4> oh, so it;s better to use lenght everytime
<4> i will use 10 for name, streen, city
<8> why?
<4> it should be sufficient
<4> Because they differ in first ten chars
<4> and there is no need to put index on whole column
<4> http://dev.mysql.com/doc/refman/5.0/en/create-index.html
<4> Docs say that
<4> If names in the column usually differ in the first 10 characters, this index should not be much slower than an index created from the entire name column. Also, using partial columns for indexes can make the index file much smaller, which could save a lot of disk space and might also speed up INSERT operations.
<8> you need index on full column if you want sorting..
<8> but whatever
<8> depends on what are you optimizing
<4> Yeah i need sorting..
<8> !m zimnyx how mysql uses indexes
<11> zimnyx: (How MySQL Uses Indexes) : http://dev.mysql.com/doc/mysql/en/MySQL_indexes.html
<8> =)
<4> domas: i read it on paper now:)
<9> /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
<4> and "How mysql optimizes ORDER BY"
<9> no one is familiar with the above error
<8> gnube: files not owned by mysql
<8> zimnyx: right ;-)
<12> gnube: Sounds like you've just installed mysql and it may not be set up correctly
<9> domas, They are actually owned by mysql
<9> -rw-rw-r-- 1 mysql mysql 8K Feb 14 2005 host.frm
<8> gnube: then directory is not
<8> then above directory is not
<8> then selinux is enabled %)
<9> drwxr-xr-x 5 mysql wheel 1K May 29 11:41 mysql
<9> selinux not enabled (BSD)
<8> sebsd then ;-p
<9> the dir is chgrp'd wheel, does that make a difference?
<8> !perror 13
<11> System error: 13 = Permission denied
<9> ok
<9> permissions . . .
<9> do they have to be 660?
<9> or can they be 664?
<8> su - mysql
<8> and try reading the files
<8> changing directory there, etc
<13> hi
<9> domas, Thanks for the help, I got the db started and you were right about permissions
<9> I did a dirty hack and changed the permissions to something nasty (755)
<9> but I will gradually change them back
<8> =)
<8> sure I was right
<8> it ain't any magic
<14> in a .sql script, is there a way to set the default storage engine?
<4> domas: I can;t find in docs that ORDER BY needs index on whole column.
<14> and charset?
<15> I am trying to move a database from on server to another and am getting an error. It appears that the database has a field that is named from.... how can i get mysql to accept this field name? `from`?
<8> zimnyx: that is obvious!!!
<8> Sonderblade: sed :-)
<1> LOL karma
<1> were you bad in a previous life ?
<1> :P
<8> karma: `from`
<15> domas: thanks :) now i am getting another error...crap
<4> karma: how did you make a copu of database?
<15> zimnyx: I am using phpmyadmin
<4> karma: Do you run linux?
<15> zimnyz: I have moved a ton of databases and never run into this... yes linux
Return to
#mysql
or
Go to some related
logs:
gentoo could not load XKB keymap
#kde
#gimp
#ai
ERROR: x11-plugins/e_modules-9999 failed
#linux
#suse
#physics
LDAP slapmodify
#asm
|
|