| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> ?
<0> or in this case: mysql -uroot
<0> just that doesnt do it?
<1> ERROR 1045: Access denied for user: 'username@localhost' (Using p***word: NO)
<0> then reset the p***word
<2> heh
<0> read on that
<0> infi: how do i use the bot to show a link for resetting the p***word?
<3> then mysql -u root -p then press return at the prompt
<2> !man reset p***word
<4> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<0> there we go =D
<5> heya, how can i make an update statement only update the first row returned in the where clausule?
<2> limit 1
<5> thanks
<1> !man reset p***word
<4> (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<6> testtt: I would make sure that the query in question has deterministic ordering...
<5> it does
<7> PHP version >= 4.1.0 Yes
<7> - zlib compression support Available
<7> - XML support Available
<7> - MySQL support Unavailable
<7> still don't understand
<7> :((
<6> testtt: super, just thought I'd mention it :)
<8> LuCkYaN, #php
<0> LuCkYaN: it isnt loaded in the conf
<5> yeah thanks
<0> LuCkYaN: he;'s right, ask in the #php channel
<9> I am using MySQL 4.0.25 What is wrong with this SQL snippet -> http://hashmysql.org/paste/viewentry.php?id=1388
<0> buahahahahahaha~~~
<0> i so need better missions...
<2> tonisius, wha ?
<10> Hey, where should I start looking when a "Table" is full (plenty of disk space)
<3> !man table is full
<4> (SET Syntax) : http://dev.mysql.com/doc/mysql/en/SET_OPTION.html
<10> archivist: hmm... looks like max_heap_table_size is the culprit...
<10> archivist: thanks.
<11> i've got mysqldump working with the options i want, but is it possible on a win2k machine to add a timestamp to the filename? Thanks in advance.
<10> ok... looking at it more closely, that should just be for heap size... I'm using myisam tables
<1> i still can not loging to the dang server
<1> ??
<12> hey
<1> ok do i stop mysql via unix <<
<1> i run ps -a i dont see teh job pid
<1> its not listed
<13> try ps -auxw | grep "mysql"
<14> adam, did you already ask them?
<15> before
<14> i have a problem using phpmyadmin to upload an SQL database, can someone help me please?
<16> hi all , someone know why i after install mysql i not have a root p***word and the database mysql?
<1> k that got it
<13> Hor no p***word for root is the default option you need to set the p***word if you want.
<15> anyone help ?
<15> me or [San[?
<16> karthik_2000b: yes but when i try put the root p***word the system retur an erros
<17> [San]: phpmyadmin often has trouble with that. It's not the appropriate tool for that job.
<13> what error
<15> how can we get around that inviso?
<14> http://pastebin.com/536153
<14> we get that
<2> heh
<16> karthik_2000b: one moment
<17> you don't really "get around it." It's a timeout/filesize issue typically
<17> why not use the command line tools or mysql administrator/query browser?
<14> where?
<13> or mail to sys admin he can do it :)
<15> of godaddy?
<14> yeah?
<17> if it's a sql file and you have shell access, mysql -u user -p db_name < my_file.sql
<14> sorry, where would I do that?
<17> from the command line on the server
<13> other way is to dump table by table or db by db, one at a time so that its much faster
<16> karthik_2000b: http://pastebin.com/536212
<18> hello, i have two table that have a field with the same name, i'm doing an inner join on these tables and i refer to the table.field for that, I am not selecting these fields in the select, yet mysql complains unless i add one of the 'ID' fields to the select and rename it, is there any way to do this with out returning it in the result?
<18> (the duplicate field is called 'ID')
<14> where is the command line?, the PPHMyAdmin query table?
<2> ...
<13> Hor: try this http://pastebin.com/536214
<14> i'm sorry, I am a noob
<14> :(
<17> [San]: are you working with a "host"?
<8> Being a "noob" is no excuse.
<17> [San]: or do you own the servers?
<15> godaddy
<14> yes, I am transfaring a website
<14> to a host on godaddy
<17> contact the hosting providor directly then.
<14> ok
<19> how will you suggest me to make a search query? using a where `name`='micro' or in any other way?
<14> thanks
<13> godady are only domain name providers right do they provide hosting too.
<8> karthik_2000b, www.godaddy.com
<13> it was long time since i checked that I was using opensrs
<20> Hi all. I am playing with my 1st PHP MySQL database frontend. I have it adding records from the PHP page, but I am having trouble with ENUM type in the database, and Multiple Select listbox on the PHP form... IS there something special I need to do?
<16> karthik_2000b: http://pastebin.com/536218
<16> :(
<13> Hor and you were using root user right
<16> karthik_2000b: yes
<13> thats strange
<16> karthik_2000b: i not have the mysql f
<16> database
<13> actually for user root you should seee mysql table.
<21> iMacGyver: what's your actual query and what does mysql "complains about" exactly ?
<8> h0rk3d
<13> can you re-install mysql and try.
<18> zeitoun: it's a big query, just a sec
<8> Don't need to re-install MySQL!
<21> iMacGyver: paste it on hashmysql.org/paste/
<16> karthik_2000b: yes, ok tks
<18> zeitoun: doesn't work: http://pastebin.com/536222 works: http://pastebin.com/536223
<18> zeitoun: error: Column 'ID' in field list is ambiguous
<13> mysql_install_db is the script which generates these tables db, host, user etc
<13> I am not sure which way you installed mysql
<22> question whats the fastest way to count rows in mysql table
<13> but if you did from scrath then you can use the same script to re-generate these tables.
<22> without using too much server power.
<13> not sure I always using -> select count(row) from tblname
<13> row = col
<22> i see
<13> select count(colname) from tblname
<13> http://dev.mysql.com/doc/refman/5.0/en/counting-rows.html
<13> they use * but I never use * in my query.
<23> * works differnetly from col
<23> * counts rows, (col) counts non-NULL values
<23> not the same thing at all
<22> meh k
<23> the manual is quite clear on that I believe.
<17> and the optimizer can cheat for * if you're using MyISAM
<23> aye
<2> but not on InnoDB?
<17> nope
<2> *cry*
<17> has to do a full index scan in InnoDB
<13> arjenAU:counts rows, (col) counts non-NULL values does this work for you
<13> actually you will get error i believe
<17> karthik_2000b: if arjenAU is wrong, I'll get your address and ship you a cake... internationally if I have to :)
<13> Thats quite a response.
<13> actually was reading the manual
<24> porno with Jenifer Lopes come to http://host4you.land.ru
<13> and i saw this
<13> mysql> SELECT owner, COUNT(*) FROM pet; ERROR 1140 (42000): Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
<23> karthik_2000b: which has nada do with my answer and everything with you mucking up your syntax ;-)
<17> karthik_2000b: sure. That's not proper. arjenAU was pointing out that count(*) and count(col) work differently
<23> karthik_2000b: if you do a count, what value do you expect owner to be??
<17> the "right" one, of course ;)
<13> ah may be i misunderstood thanks
<23> from the manual:
<23> COUNT(col) Returns a count of the number of non-NULL values in the rows retrieved by a SELECT statement.
Return to
#mysql
or
Go to some related
logs:
#centos
broken pipe icon
#debian
masquerade -j postrouting ubuntu share internet connection
buil-essential
#fedora
#fedora
dns first request fails -squid
gen2dmraid linuxrc
showkey Couldnt get a file descriptor referring to the console
|
|