| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> no clue :) sorry.
<1> is there any easy way to pipe the output of a SQL query in CLI to a file?
<0> --batch
<2> into outfile?
<2> !man INTO OUTFILE
<3> Nothing found.
<2> !man OUTFILE
<3> (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<0> if you just want a better way to view the output:
<0> \P less
<4> hi
<4> how can i store ip adresses ?
<4> cause i was using varchar which is wrong
<4> and how can i convert them ?
<5> hi all, if i have table with field id_field, which can repeat values, how to get max count for this fields
<5> i have to gorup by thsi field but how to select the count
<6> hmm i have tinyint field (f1) with cardinality of 8, if i index it and do a SELECT * FROM t1 WHERE f1 IN(1,2,3) ORDER BY id DESC; it takes almost 1second to run, but if i drop the index on f1 it takes 0.00xx sec to run ...isnt this a little odd?
<7> if i do "SELECT * FROM Table WHERE ID IN ('5', '3', '1')" will the results be returned in the same order that the ID's are listed?
<8> hello all
<8> How would I save a date range in my db? For example, 2000-2004
<9> thirdLibr, no
<8> and then be able to query it so that it displays as a result for, say, 2002?
<7> NO?
<9> it'll show them in the order they are in the table
<9> use order by if you want to order them 5 3 1
<7> Jy: can you be more specific
<9> SELECT * FROM Table WHERE ID IN ('5', '3', '1') ORDER BY id DESC
<10> hi
<10> mysqldump does a INSERT statement on auto_inceremnt - can i turn that off?
<10> this is a extract of my sql file http://rafb.net/paste/results/wDDKbC45.html why is the ZeitungsID primary key always 1 :S
<10> auto_inceremnt is ignored :(
<11> !tell me about random
<10> can anybody help me? :S
<12> hey folks: I have an AMD server with Red Had Enterprise3 64 bit. Which version of MYSQL should I pick up?
<13> You may notice at http://dev.mysql.com/downloads/mysql/5.0.html that there is a RHEL3 AMD64 download section Noel4DMB, I'd start there.
<12> those are RPM's though?
<13> And?
<12> what's the difference between RPM's and source
<14> RPM are easier to install
<15> RPM is the packaging system that Red Hat uses. You might have noticed that everything else on that server was installed via RPM. :) They contain compiled programs, ready-to-install.
<12> oh ok
<12> Red Hat Enterprise Linux 3 RPM (AMD64 / Intel EM64T) downloads
<12> that what im looking for?
<14> and RPM's check dependies
<16> hi how can i see the privileges of a user ?
<15> show grants on 'user'@'host'
<16> ok thanks !!!
<12> should I execute my rpm's in /home/user or /usr/src/redhat/rpm
<17> show grants for? or does on work too?
<15> noel: Not the second one. You just install an rpm from anywhere, you don't have to keep the file around afterwards, but /usr/src/redhat/rpm is the directory in which local RPMs can be built.
<15> for? on? one of those :)
<12> ok thanks
<16> is for
<16> show grants for
<7> how long does a temporary table last?
<14> till session is killed
<17> until the connection is closed or until it's dropped
<11> thirdLibr: till you disconnect or drop it
<7> cool
<7> thanks
<11> thirdLibr: note that it is connection specific, other conn cannot see the temp table
<14> lokus is trying for extra credit
<12> rpm -Uvf *.rpm <-- correct?
<7> lokus: if say this is on a website using php, does one user have one connection or is it shared?
<17> each user has their own, generally one connection/page, unless for some silly reason you use pconnect
<7> yikes
<7> looks like my mysql cl*** is
<12> do you guys know where i can get perl-DBI rpm
<14> Google ?
<15> noel4dmb: From your OS vendor, preferably. Look for it at rpmfind.net
<14> or dbi.perl.org
<11> cpan ?
<15> No, really, from your OS vendor.
<15> There are no RPMs on cpan, and Red Hat distributes DBI.
<12> i have a DBI-1.50.tar.gz in my /usr/src/redhat/SOURCES
<12> i should probably use that right
<15> Gah, no.
<15> You should use the RPM! from your OS vendor! Like I answered when you asked.
<15> The binary RPM, not the source RPM.
<12> thats what I have on my server. I went to redhat.com and it didnt provide options for RPMs
<15> ...
<15> Take your RHEL3 CDs, insert, run up2date or whatever the supported package manager is. Or go to rpmfind.net like I said.
<15> If you can't get the rpm you need from your CDs or from up2date, then use rpmfind.net to find the most recent perl-DBI rpm *for RHEL3*.
<12> Red Hat Enterprise Linux 3 sources for AMD64 perl-DBI-1.32-5 <-- look right?
<15> No, not sources.
<15> (10:41:44) mendel: The binary RPM, not the source RPM.
<15> It will be "perl-DBI-VERSION.x86_64.rpm", probably.
<15> But really, you're paying RH for up2date, use up2date. :)
<12> I have a remotely hosted server
<12> so i dont have CD's
<15> Right, so you should use up2date, which is part of RHN.
<12> how do I do that? This is my first self-maintained server
<15> I don't buy RHEL subscriptions, I use centos, so I'm not sure how to configure RHN.
<15> But if all else fails, grab the perl-DBI RPM from CentOS 3. CentOS is RHEL-for-free.
<12> perl-DBI-1.32-5.src.rpm
<12> how do I check to see if I've got RHEL3 or RHEL4?
<14> cat /etc/redhat-release
<14> Noel4DMB ... Google could anwser most of your questions
<18> if two columbs are set as an index (together), should a REPLACE still function as expected?
<14> yes
<14> will[werk] wb
<18> heh
<18> thanks
<14> it's nice to know you still have no life
<18> heh, yup
<19> Weirdos.
<12> error: Failed dependencies:
<12> perl(lib::mtr_cases.pl) is needed by MySQL-test-standard-5.0.22-0.rhel3
<12> i installed the perl DBI rpm though
<12> why's it freaking out at me? lol sorry for all these questions
<12> how do I configure mysql to look in the right directory for mysql.sock? It's currently trying to use /tmp/mysql.sock but it exists in /var/lib/mysql/
<9> edit the my.cnf
<9> in the [client] section
<12> hmmm. locate my.cnf doesnt bring up anything.
<9> what distro?
<12> RHEL3 64 Bit AMD
<9> how did you install mysql?
<9> using the offical rh rpms?
<15> noel: You just installed it a minute ago, didn't you?
<12> mendel: yes I got the RPM's from the section you specified.
<15> noel: The locate database is updated nightly. It's in /etc.
<15> er, "my.cnf is in /etc"
<9> you have to re-run updatedb in order for locate to work
<12> i did
<12> . /usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
<12> thats what i got when i executed the RPM's
<20> re
<12> ohh
<12> i have to copy the CNF over. i have a couple of different places that have the CNF file. Should i use /usr/share/mysql, /usr/share/doc/Mysql-server-standard-5.0.22 ?
<21> what is the easiest way to have a replication slave send out a notification e-mail when the replication is broken/interrupted?
<22> monitoring tool
<21> alright, so there's nothing built directly into the server for such a thing?
<23> monit is an awesome project
<23> such functionality is beyond the scope of responsibility of a dbms imho
<21> thanks cythrawll thats what I thought
<24> is there a way to share mysql databases between windows and linux ?????
<24> symlinks ?
<24> (im on a dual boot)
<25> no
<24> hum, that ****s
<25> unless you want to have a fat32 partition in linux
<25> for the database
<9> well there is if your windows ia fat32
<9> ya
<25> which is a BAD idea
<24> yeah my windows is on fat32
<26> hi
<9> or you get a ext2/ext3 driver for windows
<24> which files do i have to share ?
<25> solution: go to http://retrobox.com and get a cheap p3 server and use it for your db
<24> and how do i point to them ?
Return to
#mysql
or
Go to some related
logs:
#gentoo
#bind
ubuntu fsck bread:
s2ram overlay
ajax inputDate
ubuntu sound driver laptop compaq presario v5000
#linux
samba *** glibc detected *** free(): invalid next size (fast):
#php
#kde
|
|