| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
Comments:
<0> d'oh!
<1> Folks, mysql crashes frequently. where can i find docs on how my.cfg ? http://hashmysql.org/paste/viewentry.php?id=1667
<0> jade: sudo emacs /etc/hostname
<1> cj, why?
<0> jade: 'cuz you haven't set it
<0> jade: also, please give us the output of that perl script
<2> if i want to alias my field names, so that i can have them relative to a certain value in a sql script, can i do this
<0> lorfds: what are you doing now? paste the output and tell us what you want it to say instead
<0> rafb.net/paste is good
<0> or the hashmysql.org/paste/
<2> k
<2> one sec
<2> (2, 1047, 'CompanyId', '', 2, 'n', 'n', 'n', 'n', 'n', 'y', 'y'),
<2> here is an example of a record i want to insert
<2> 2 is the fieldId
<2> 1047 is the countryid
<2> however, depending on the country id, i want the field id to change
<2> and i want to write a sql script that does things based on the country id
<2> so if country id is 1000, then field id will be 2
<2> if country id is 1001, then field id will be 2+9
<2> i country id is 1003, then fieldid will be 2+9+9
<3> do you mean 1002 ?
<2> sorry, i meant to say if country if is 1002, then fieldid will be 2+9+9
<2> so it is a pretty simple increment based on what the divisionid is
<2> im trying to figure out whether i can code that in sql
<3> so fieldid = countryid-988 + 9*(countryid-1000)
<3> ops wrong
<3> so fieldid = 2 + 9*(countryid-1000)
<3> provided countryid is >=1000
<3> is that your formula
<2> right
<2> cool
<2> that seems like it should work!
<3> not so sure if it works in INSERT or not
<1> cj, ah well i don't have the original error messages, but they were on different occ***ions 'Lost connection to MySQL server', 'Can't connect to local MySQL server through socket', and 'MySQL server has gone away at'
<0> jade: nice. did you have any server logs to go along with those?
<0> jade: can you reproduce?
<0> max_connections = 1000
<0> so if you call that db_connect function a lot (sounds like it), you'll get those errors
<0> jade: but you shouldn't have to create more than one connection, unless you're doing something weird :)
<1> cj: yes i have max_connections = 1000. i checked around for how to get mysql to start logging error messages, but could not figuring out how config mysql to do that other than the my.cnf statement 'log-bin=mysql-bin'. BTW, here is the perl script i run with 200 times http://sial.org/pbot/16640
<1> cj: i've been looking and looking thru the docs, trying to find out what the settings in my.cnf mean
<3> jade: error log is automatically created
<3> there should be a file with the extension err in the data directoru
<0> jade: debian keeps 'em in /var/log/mysql/ methinks
<1> OK, the /var/log/mysql.err is empty (!)
<0> /var/log/mysql.log
<1> cj: that is empty too.
<0> ps awx | grep mysql
<0> sudo /etc/init.d/mysql start
<1> http://hashmysql.org/paste/viewentry.php?id=1669
<0> so, is mysqld running?
<4> is there a way I can dump the contents of show tables to a file? like a select into outfile?
<1> cj: here is output of ps -efl | grep mysql... http://hashmysql.org/paste/viewentry.php?id=1670
<4> I've done a mysql dump, but I'm trying to make a nicer-looking list of tables for my boss to see
<5> i can't start mysql
<5> Fatal error: Can't open and lock privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
<0> furio: echo "SHOW TABLES" > foo.sql && mysql -u foo -p < foo.sql > outfile.txt
<4> cj: beautiful, why didn't I think of that! thanks
<0> jade: there's your problem. check /usr/local/var/log/mysql.err ?
<1> hehe, why not mysql -e "SHOW TABLES" ?
<1> hehe, why not mysql -e "SHOW TABLES" -p foo?
<1> cj, ok
<3> !perror 13
<5> can someone tell me what's the host.rfm file
<0> jade: did you compile your own mysql and install it in /usr/local ?
<0> or maybe just install to /usr/local/ ?
<3> M3: how did you install the mysql server?
<3> M3: the error usually due to incomplete installation
<0> M3: updatedb && locate host.rfm
<5> lokus, i just unpacked the binary
<3> M3: please read the installation steps, there are a couple of things you need to do
<5> i thought i did
<3> M3: here http://dev.mysql.com/doc/refman/5.0/en/installing-binary.html
<5> i'm reading 2.7 out of the 5.0 docs
<1> cj: OK yes, mysql diagnostics in .err log was '/usr/local/mysql/bin/mysqld: Out of memory (Needed 357273600 bytes)'
<3> M3: all the steps are there, make sure you perform each and every one of them
<1> needed nearly 350 MB to finish op
<1> perhaps i need to allocate more memory to mysql
<1> cj: I used mysql-standard-5.0.19-linux-i686-icc-glibc23 from mysql.com
<1> perhaps i am running too many processes then... but there should be good swap space to cover it.
<1> cj, thanks
<6> o/ Hi all. I am trying to get a PHP frontend for a mySQL db working. anyone super familiar with resolving this set of errors? --> http://www.rafb.net/paste/results/ScYN4Z60.html
<6> ...OR... know the trick to setting up mysql with PHP 5.x ? Since it comes bundled with PHP 4.4, I'm using that version but that is causing problems of it's own..
<6> Win XP Pro, IIS 5
<3> Stronith: http://dev.mysql.com/doc/refman/5.0/en/p***word-hashing.html
<3> Stronith: answers available in the url above
<6> thanks. this is a new URL for me to look at
<3> Stronith: this is actually link to 1 section in mysql ref manual
<6> i see that, thanks. hope it helps .... reading .... ;)
<1> im too lazy to stop working
<7> hey how do i drop a DB within term?
<7> erm as in what command
<8> DROP
<8> from mysql client you mean yes?
<7> erm full command
<8> DROP DATABSE mydatabase
<8> good documentation on it in the mysql docs
<8> can also drop databases with mysqladmin but I don't know the syntax offhand
<9> hello all, I am trying to install mysql 5 from an rpm and it keeps telling me I need libmysqlclient.so.10 but it is on the machine
<10> I'm having mysql replication problems. It'll work for a few days from a fresh copy, but I always seem to get Error's that gum up replication.
<10> is there a way I cna tell it to skip errors? the erros i'm seeing are duplicate entry errors, so I'd love to just skip them all
<11> kpettit: Your data is dorked, fix your data.
<12> I have some fields that are set up as varchar() and sometimes they have a number in them, if I want to find the MIN() of the field, what's the best way?
<12> MIN(if(cast(field2 AS unsigned) > 0, cast(field2 AS unsigned), NULL)) AS min
<12> I have that...but want to know how I can simplify it, cause it's ugly :)
<10> [RainMkr], it's fustrating cause I don't know what's causing it. I copied all the data fresh a few weeks ago becuase i was having this same problem
<13> quit
<12> I want to ignore 0 or NULL values
<14> hi
<15> hi folks
<15> is there a tool to take a postgresql query and convert it to a mysql one?
<11> Frawg: No
<15> [RainMkr]: doh
<11> MIN( field2 ) AS field2_min WHERE field2 > 0
<15> need to take a view from pg to my
<14> sorry for the ot question but i don't know where to ask, i have a .gdb file, it is a firebird database, i want to read it, how can i do it?
<15> although it's giving me ERROR 1111 (HY000): Invalid use of group function
<11> dob1: #firebird
<5> thanks lokus
<15> but maybe that's because i'm on an old version of mysql
<12> [RainMkr]: I have other fields in that table that I want to take min of also, so I can't use that :/
<14> [RainMkr]: it's empty
<11> Frawg: What version?
<5> lokus, that's the exact page i was following
<11> dob1: Then I'm guessing your SOL.
<15> [RainMkr]: 4.1
<11> Frawg: VIEWs where not introduced until 5.0
<11> Frawg: it should fail on the CREATE VIEW statement.
<15> [RainMkr]: hrmm
<15> [RainMkr]: http://pastebin.com/645364
<15> that select statement fails regardless
<11> Frawg: There's no view there.
<11> Frawg: You can't have a GROUP BY in the subselect.
<15> doh
<15> any reason why you can't?
<11> Frawg: Not sure if that limitation is lifted in 5.0 or not.
<15> hrmf
<15> *pulls hair out*
<16> [RainMkr]: It's been fine since 4.1.
<16> Frawg: What version are you using?
<11> Xgc: Humm... what am I thinking about then?
<16> [RainMkr]: Not sure.
<16> Frawg: You're fine with 4.1. What is your question?
<15> Xgc: 4.1.18
<15> Xgc: why that fails with ERROR 1111 (HY000): Invalid use of group function
<17> is mysql cluster a real failover solution?
<0> yxa: define "real failover solution"
Return to
#mysql
or
Go to some related
logs:
how do i check mysql version
perl6 imaginary timeline
grub hwo-to
cyncromatic
#kernel
unknown arg --to-ports
#linux
treading in c++ + tutorial
#math
a little shoggoth
|
|