| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
<abrotman> Ungy: you could just use sarge :)
<kombi> Ungy: just configure smb.conf right
<flipmcf> Zainzzz, no, referring to error, not your style :)
<Ungy> abrotman but I like bluefish editor
<Zainzzz> Darien: is there any way that mysql could STOP formatting numbers with exponent values ?
<abrotman> Ungy: bluefish is in sarge
<Ungy> kombi it is a version conflict
<flipmcf> zainzzz, try darien's sugestion. simply quote.... are you quoting?
<granden> How do I create a new suer with full irghts for mysql?
<kombi> grant
<Zainzzz> no... i'm using php and quoting isn't done on integers in the script i'm using
<tradergt> !m granden grant
<SQL> granden: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<Ungy> abrotman really ok I can switch back to sarge
<abrotman> Zainzzz: are you sure PHP is inserting as that long string?
<flipmcf> !m granden adding users
<SQL> granden: (Adding New User Accounts to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_users.html
<abrotman> Ungy: packages.debian.org/bluefish
<flipmcf> tradergt, not to step on your toes :)
<Ungy> abrotman Iwill use sid like I always do
<tradergt> oh, you are, go to hell, you go to hell and die! ;)
<abrotman> Ungy: ah ok
<flipmcf> Zainzzz, well, an option is to actually edit the php script. I would not fear. That's what open source is all about
<Ungy> abrotman I am used to windows I need somethign to botch about
<abrotman> heh
<kombi> people, I have a real problem here: this damn db (i might have mentioned it before) contains some 300 tables, I really wonder how I ever get to see them all using mysql monitor since that thing alway flicks through to the last
<flipmcf> Zainzzz, also, you could try to change the column type to CHAR instead of varchar
<granden> bash: mysql: command not found
<Ungy> so using sarge is too safe no reason to ***** ;-(
<granden> why do I get that
<Zainzzz> abrotman: php is inserting that as in integer.. But i would rather want mysql to take it as a string if defined as a column type or so
<flipmcf> Zainzzz, but I'm simply avoiding the question.
<flipmcf> ah, it's php that's the culprit
<Zainzzz> flipmcf: oh wait.. lemme try that
<kombi> granden: whereis mysql
<abrotman> Zainzzz: have you tried the integer->string function ?
<Ungy> kombi how about you save query result to file
<granden> kombi: I installed mysql with apt-get
<flipmcf> Zainzzz, or quote within php?
<granden> in debian testing
<Zainzzz> flipmcf: i'm trying char right now :p
<kombi> granden: type this command: wheris mysql
<Ungy> granden apt-get install mysql-client
<kombi> Ungy: like show tables into outfile? not sure whether that will work..
<granden> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<granden> ?
<flipmcf> Zainzz, but if php is doing the conversion, then it's the string "123456789e+48"
<abrotman> erm .. maybe that was string->int ...
<flipmcf> and that's still a valid string.
<Ungy> granden you trying to connect from the same machine?
<flipmcf> so the column change won't help
<abrotman> Zainzzz: if you echo the variable in PHP .. is it scientific or correct?
<kombi> granden: it's not running...
<Zainzzz> lemme see that
<flipmcf> abrotman, good call
<granden> Ungy: yes
<kombi> granden: etc/init.d/mysql start
<granden> kombi: how do I start it if its not running
<Ungy> granden /etc/init.d/mysql start
<granden> bash: /etc/init.d/mysql: No such file or directory
<Zainzzz> ,01234567890123456789012345678901234567890123456789,NOW
<Zainzzz> its the actual number
<flipmcf> !m granden starting the server
<SQL> granden: (Starting the Server for the First Time) : http://dev.mysql.com/doc/mysql/en/Windows_server_first_start.html
<kombi> granden: whereis mysql
<granden> Dont have any mysql file in there
<Ungy> granden, run this command "apt-get install mysql-server"
<kombi> is he on debian?
<Ungy> yes
<kombi> not everyone is you see..
<flipmcf> apt-get install mysql-server41 :P
<abrotman> invalid package
<Ungy> 4.1
<flipmcf> abrotman, was a guess :)
<granden> Oh I had only installed mysql-common
<SurcouF> mysql-server-4.1
<flipmcf> thanks SurcouF
<Ungy> granden well that woudl explain why it isn't working
<Ungy> apt-get install mysql-server-5.0
<flipmcf> is 5.0 available in testing? unstable?
<abrotman> Zainzzz: if you look at the logs .. does it show your query?
<kombi> debian is spoiling you, nobody knows how to really install things anymore..;)
<Ungy> flip I am using it right now
<abrotman> Zainzzz: might be nice to narrow it down to PHP or mysql
<flipmcf> Ungy, stable? unstable? testing?
<tradergt> 15 is stable
<Ungy> kombi that is bull**** I can look and see how the package installs ;-)
<granden> is it possible to change the p***word for a account?
<Ungy> flipmcf, I run unstable but I know 5.0 is in etch arwell
<Ungy> granden for root?
<kombi> Ungy: the package that is allways 2 versions behind..
<granden> wtf it says my admin account dont have any priviliges
<granden> but I did as the guide said
<Ungy> !m granden setting root p***word
<SQL> granden: Nothing found
<abrotman> http://packages.debian.org/cgi-bin/search_packages.pl?searchon=names&version=all&exact=1&keywords=mysql-server-5.0
<abrotman> it's .. the RC ?
<Ungy> granden mysql -uroot
<Ungy> granden that has full priveleges
<granden> ah but Im using phpmyadmin
<granden> but thanks
<granden> and there is a option ot change apssword with in it
<flipmcf> abrotman, how can I make unstable packages available without fully dist-upgrading? Is it possible? Simply edit sources.list?
<Ungy> granden phpmyadmin lets you connect with no p***word?>
<SurcouF> yep
<abrotman> flipmcf: /msg dpkg simple sid backport
<abrotman> flipmcf: or check backports.org
<granden> Ungy: yes
<granden> But I did set a p***word now
<abrotman> flipmcf: http://www.backports.org/pending/
<abrotman> flipmcf: and oyu have to be in #debian to msg dpkg afaik
<flipmcf> abrotman, yeah, noticed :P
<don-o> whats the different between tablename.MYD and tablename.MYI (trying to recover a mysql table)
<Ungy> abrotman really oh I didn't know that
<Ungy> !man fiile types
<SQL> Nothing found.
<Ungy> !man file types
<SQL> Nothing found.
<flipmcf> abrotman, "or pay someone to do it properly :)" says dpkg LOL
<flipmcf> don-o, data and index, iirc
<flipmcf> !man myd myi frm
<SQL> Nothing found.
<flipmcf> !man myi
<SQL> (How to Check MyISAM Tables for Errors) : http://dev.mysql.com/doc/mysql/en/Check.html
<don-o> flipmcf: hmm. ive got the table.MYD and table.frm files. Ive put them into /var/lib/mysql/database_name, and i can see the table in 'show tables' but doing a select on that table says it cant find the MYI file.
<don-o> flipmcf: is there a way to generate the MYI file from the MYD file?
<flipmcf> !man repair MyISAM
<SQL> (Repair Options for myisamchk) : http://dev.mysql.com/doc/mysql/en/myisamchk_repair_options.html
<flipmcf> don-o, never done it myself. become the pro :)
<don-o> :)
<don-o> thanks for the url.
<flipmcf> np
<flipmcf> good luck
<abrotman> flipmcf: good plan .. pay!
<Exnor> hey
<Ungy> why is xemacs21-basesupport described as editor and kitchen sink?
<Exnor> despite me specifying the LIMIT keyword, my query is still scanning the entire table
<Exnor> i'm guessing this is normal
<Ungy> limit is done at return level
<Exnor> although I would expect LIMIT to stop the thing scanning the table after 2 rows
<kitchen> because I use xemacs to wash my hands in?
<Exnor> i see
<kitchen> M-x wash hands
<Ungy> Exnor, hence why limit allows order by's
<Exnor> ah right
<Ungy> when will I ever get out of this damned place
<will[werk]> !kick Ungy now
Return to mysql
or
Go to some related
logs:
hyöööörrrghhhh
sy en väska
rock
wg111v2 treiber
|
|