| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> uhhhhhhh
<1> server still running, but no mysql.sock
<0> then restart the server
<1> i cant
<0> well then you can't get the sock back
<2> figured it out
<1> =\
<2> mysql_num_rows
<0> the server creates it
<2> thanks for any help
<1> bad
<3> hi all
<1> no way without restart ?
<0> nope
<1> it wasn't manual remove..
<1> i guess some technical mistake
<3> after a problem with my database, I look binary log files..., but never is writed since one month, what is the problem ? I will do a flush logs to tell mysql write "cache" log ?
<4> hello
<5> hey all...i have a question i am doing a query then a fetch ***oc on that. The thing is I want to get some information off the next row while i remain on the current row how would i do this?
<6> hi
<6> /etc/p***wd to mysql work ?
<6> i'm problem with /etc/p***wd with linux
<6> hehehe
<6> migration to mysql work ?
<7> napnap: is binary log enabled?
<7> napnap: try SHOW master status;
<8> if I have 2 tables and I want to update the value of one thing in the first table depending on what the value for it is on the second table how can I do the query?
<3> lokus, yes, and I see another thing, I've 7 binary Log (1..2...3 etc...) but all are identical
<7> identical? usually it is incremental,
<7> flush logs force it to start a new log file, restart mysql and file exceed max size configured also start new file
<3> lokus, yes, log are incremented, but they contents are identical
<7> napnap: are you sure?
<3> SHOW MASTER STATUS => binaryLog.000010 (Position : 189218)
<3> lokus, sure, winmerge say that ;)
<7> it means it is currently writing to file 10
<3> yes
<3> but no
<3> the last line correspond to a query of one month
<3> and I use the database every day
<3> :\
<7> napnap: try mysqlbinlog to read the log file 10
<6> napnap p***wd to mysql work ?
<6> i'm problem with /etc/p***wd with linux
<3> I've already read it
<7> contraventor: mysql does not use /etc/p***wd
<7> napnap: and it is 1 month ago?
<3> lokus, yes
<6> lokus hmmm
<3> lokus, wait
<3> in fat
<3> in fact
<6> lokus with shadow work ?
<3> I think I've do an error
<3> :-S
<7> contraventor: mysql has it own p***word stored in a database table
<9> mysql> select sum(bar) from foo;
<9> | NULL |
<3> lokus, no sorry, log are not identical...I'm stupid
<7> contraventor: unless you refer to the unix user with the id mysql
<9> wtf?!?!
<9> bar is int
<9> table is empty
<7> IceD^: do you get 0 ?
<7> IceD^: obviously you got NULL
<9> lokus: yes!!! NULL!!! and that's completly crazy
<10> sum(emptycol) = null
<3> ok everything is ok, thanks
<10> use coalesce if you want to return 0 instead
<9> gleam_: what is coalesce
<9> and you mean that's correct behaviour?
<10> yes, that's the correct behavior
<10> !m IceD^ working with null
<11> IceD^: (Working with NULL Values) : http://dev.mysql.com/doc/mysql/en/Working_with_NULL.html
<12> wow will you are here quite a bit
<12> oops (I just learned to scroll down first)
<13> LMAO Morning, Jx.
<9> sum from zero elements is 0, not NULL
<12> well here is my situation, I am trying to install a forum and I really do not need to know a bunch about MySQL, I got it running but I need a database created; a username for the database; and a p***word for that database. If anyone knows a quick way to get that going I would appreciate it
<10> according to whom iced?
<9> but yes, postgres does the same
<12> would this be correct? "mysql -h host -u root -p forum" ?
<10> that will use database forum and prompt for a p***word for user root@machineshostname
<12> ohh sorry I am using SuSE 10.1
<10> is that what you want it to do?
<9> jxmiller: -pforum
<9> or you mean db forum?
<12> database name "forum"
<12> then prompt for p***word
<10> that's what that will do
<12> is that going to create the DB?
<10> no
<12> or would it be mysql> CREATE DATABASE forum;
<10> yes.
<14> hi, I'm using mysqldump in a backup script - I know it's not very good practise to put the user and p*** in the mysqldump - is there a way I can backup the database without specifying the user and p*** on the command line?
<10> ~/.my.cnf or /etc/my.cnf or some other my.cnf
<14> ok thanks
<10> put the username=username nad p***word=p***word in a [mysqldump] section
<14> right thank you
<12> ok i did that and it created the forum DB and then I did "USE forum;" and that worked; how do I create a p***word for that DB? Or do I just use the same one I have had?
<10> just use the same one you've had
<12> ok thanks
<10> as long as it has been granted access to it
<10> with GRANT
<10> but it sounds like it has
<12> I never used a GRAANT command
<10> !m jxmiller grant
<11> jxmiller: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<12> holy crap that looks difficult
<10> grant all privileges on dbname.* to 'user'@'host' identified by 'p***word'
<10> fill in the blanks
<10> since the user exists you can probably omit the identified by bit
<10> also you can login the way you were before and do "show grants for current_user()"
<10> and see what you get
<12> so like this; "GRANT ALL PRIVILEGES ON forum.* to root@localhost identified by 'p***here'" ?
<12> the forum.* is what I am curious about
<12> and is that other command like this: "mysql> show grants for current_user()" ?
<10> sure
<12> ok I did mysql> show grants for current_user() and it did nothing but gave me a -> prompt
<10> ;
<12> ahh
<12> now its error in syntax
<12> ok i got it to work
<12> it says I got all privileges
<10> wellt hen you're fine
<10> no need to grant
<12> I am going to try to 'install' the forum now (crossing fingers)
<12> hmm how do I tell which port this is using?
<15> i've run into an issue i was hoping someone might be able to point me in the right direction on. my db seems to have lost the .MYI and .MYD files for a few tables, but the .frm files still exist. is there anything i can do to re-create the .MYI and MYD ones?
<10> are you sure the tables aren't just innodb tables?
<10> like, are you sure they're myisam?
<15> humm, actually i am not
<10> check
<10> show table status
<15> how can i know? i am a little...
<12> ok i found the port and got mysql-administrator to work
<15> okay, sec
<15> okay, i uncommented "skip-innodb" from my.cnf
<16> is there an oracle room?
<15> i have no .idb files in the db dir
<10> do you have ibdata files?
<15> and the show table status; shows all of them using MyISAM
<10> well then i think you're SOL
<10> if they myi/myd files are genuinely missing
<15> k, that is what i though
<15> t
<17> time to call Iron Mountain
<16> oracle room anyone?
<10> #oracle?
<16> i don't think so
<10> how about "not #mysql"?
Return to
#mysql
or
Go to some related
logs:
crontab seteuid: Operation not permitted
#suse
ctcp.o bitchx gentoo
#gcc
ubuntu redetect hardware
mysql date returned in american format
mysqlimport and STDIN
udev captive-ntfs ubuntu
wx-config ubuntu
unkown dav provider svn
|
|