| |
| |
| |
|
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> I was using 4.1.7 and somehow the new install they did went to 3.23.58
<0> crap!
<1> ha
<0> no wonder I'm fighting
<0> now I've got to figure out how to get mysqld upgraded
<1> I hope you also have another copy of your tables
<0> I'm sorry I've cause anyone headaches ehre......off to google to figure out how to fix this darned thing
<0> yues...I kept a copy of them on the slave drive, unaltered
<1> good
<1> :)
<0> Anyone have some quick info on fedora core 3 on how to get 4.1.7 on it?
<1> get binaries from mysql.com
<2> get.. yes
<2> :)
<1> :D
<1> chances are it'll be 4.1.28 or some such number, something higher than .7
<1> but that really shouldn't affect the data
<0> I found the original rpm's I used on the salve drive....(It's been a long time since I set this server up)
<0> ok, having trouble...how can I either 'upgrade' the current mysql install or force remove the current?
<0> I get failed dependancies if I try to remove the current rpm's for mysql
<2> You have rpms? rpm -Uvh mysql-server-4...
<0> they're installing! Yay!
<0> it works!
<0> Thank you, everyone of you, for your help and patience with me.....I'm an idiot.
<3> ooo a happy customer, send a bill
<0> Man, this ****s........the whole process of it all....yes, it all works now.....I"m just upset about what happened....
<1> np, at least you're a patient and courties (sp) idiot
<1> :)
<1> unlike the one we had to forcably remove earlier...
<0> The server was compromised due to a vulnerability in geeklog. Although the crackers were only able to run a couple of IRC bots and nothing more, server beach turned the server off and only let me use it as a slave drive.
<1> it happens (I guess)
<1> at least you're back up and running
<1> hrm, I have balls in my soup
<3> I have balls where they are supposed to be
<1> I think these are supposed to be there
<0> my balls are missing since this server issue
<4> folks trying to set up a mysql my.cnf file that is optimized for my system. i have a dual xeon server with 4GB ram. would like to be able to have up to 256 concurrent connections with simple inserts, selects, and deletes. do these config settings look good? http://hashmysql.org/paste/viewentry.php?id=1696
<4> i borrowed from support-files/my-medium.cnf and my-huge.cnf files
<5> jade: www.flupps.org/my-dw.cnf
<5> may give you some ideas too
<5> not at all configured for your workload, though
<5> but examples are quite verbose
<4> flupps|BE, thanks
<6> urp
<1> wyatt urp
<4> flupps|BE, you used dashes between variable names, i used underscores. e.g. sort-buffer-size = 16M v sort_buffer_size = 512K. does it matter?
<5> nope
<4> OK
<5> it shouldn't, if you get an error bug report it :)
<7> .
<6> ,
<7> INSERT INTO parish
<7> VALUES (1, 'Saint Andrew');
<7> VALUES (2, 'Saint David');
<7> VALUES (3, 'Saint George');
<7> VALUES (4, 'Saint John');
<7> VALUES (5, 'Saint Joseph');
<7> whats wrong with this that i get an error?
<6> Don't do that.
<8> sql question: I need to select all row_id's where there are 100 rows that have the same member_id and TMS has a difference of 3600 or less. The DB setup is as followed row_id (int 11, auto-inc), tms(int 11), member_id (int 11)
<8> I know how to do all except look for a range of 3600
<6> robcole, What error?
<3> flupps|BE how many more countries before youve done the full set
<7> like this syntax is wrong - i use version 4.0 or mysql
<5> archivist: haven't been to that many
<6> robcole, What EXACT error.
<6> lol
<7> #1064 - You have an error in your SQL syntax
<5> robcole: one ;, one VALUES
<6> robcole, INSERT INTO parish VALUES (1, 'Saint Andrew'), (2, 'Saint David');
<6> I don't know how people can make up syntax...
<5> ChillAxen: HAVING MAX(tms) - MIN(tms) <= 3600
<8> thankyou flupps, let me try
<9> is possible mysql slave run another mysql master?
<6> enerv_, Yes, possible, but you have to make sure you know what you're doing...
<9> will[werk], [MASTER1]--------> [SLAVE1/MASTER2]--------> [SLAVE2]
<10> hmmm
<8> using mySQL, does anyone here know if theres any difference in productivity between [(cond) && (cond)] or [(cond) AND (cond)]
<6> enerv_, Is MASTER2 the same data as MASTER1?
<10> whats a better way to do this.. ALTER TABLE tablename DROP IF EXISTS 'fieldname';
<6> ChillAxen, I like to use AND. Looks nicer.
<11> hello, im trying to do /usr/local/libexec/mysqld --skip-grant-tables to reset the root p***word, but it's giving me an error about Security settings. What do I need to do?
<9> will[werk], yes
<6> enerv_, Why not have one master and two slaves?
<9> will[werk], because i dont need stop my master1
<6> I don't believe you need to stop MASTER1 to add SLAVE2....
<2> fbh: For starters, you need to tell us what the error is.
<11> 060413 13:26:14 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
<9> will[werk], for add new slave i need run flush in master 1 correct?
<11> Any idea?
<3> FBH^, so dont run as root
<11> nm i got it.
<2> fbh: Did you read that part of the manual?
<2> ok
<11> i just had to add --user=root
<11> k, p***word reset, reloaded grant tables, all is well again.
<12> Am I overlooking anything from a security point of view: I'm allowing users upload files through a webform to a directory which has a .htaccess limiting GET/POST and requiring a valid-user. The idea is that PHP can still access these files but browsers cannot?
<12> Or is that fine?
<12> Also I will check if the extension is .png. (Just incase someone tries to upload malicious .php files or whatever)
<12> *pokes the 300+ users that appear to have fallen asleep*
<13> or are ignoring you ;)
<3> bugger off i am asleep
<12> Well it just requires a yes/no answer really, then you can get back to ignoring me/sleeping. :P
<14> Is there a nice way to add comments to fields in a table without having to re-state (and possibly change) its data type?
<3> wrong place to ask that anyway
<12> er
<12> Sorry, I thought this was #php
<12> doh
<12> my bad
<15> hi am i trying to start mysql wiht ssl cert but getting error
<15> rror when connection to server using SSL:1073793152:error:02001002:system library:fopen:No such file or directory:bss_file.c:278:fopen('/home/asraikhn/openssl/server-cert.pem','r')
<15> any idea if this is a known bug or i am doing something wrong
<3> what part of "No such file or directory" dont you understand
<15> archivist, all these file and direcrtories are present
<15> is signing of certificate is important ?
<16> I'm in the process of moving my server from one datacenter to another. They peer with each other. I'm trying to run the two web servers in sync. If I did replication between the two, what sort of delay would I be looking at for changes to transfer? Is there a better way?
<3> check permissions then
<16> It's a PHP Shopping cart, so it must be in sync
<16> DNS will take 48hrs to propagate, so both may be in use.
<2> frostbite: Nearly-instant is possible, but you can't do writes to both very easily, so replication is probably not what you want.
<15> archivist, I just skip the step of signing a certificate, I duno if its necessary or not
<17> dudes, is it posible to dump only a table with mysqldump? (ive been looking at a mysql doc but couldnt find such answer -if any-)
<2> Why not tell the "from" webserver to use the database on the "to" server, with an ssh or ssl tunnel between them?
<2> stereoskit: mysqldump | head -1
<2> :)
<16> mendel: surely that'd be very slow?
<2> frostbite: Slower than "local database", faster than "downtime"
<17> mendel: ^_^
<12> What does '^_^' mean? I never did know...
<2> it's a happy emoticon
<6> enerv_, Flush the master? No, you need to load the data from the master.
<2> two eyes and a mouth
<12> hmm, doesn't look very happy.
<16> mendel: how long would a query take ... ping is around 30ms and the speed is probably around 10mbit/s (need to be careful about 95th percentile billing)
<18> Hi! ***uming I have a table containing the notes of students, can I query the last note of all students?
<2> zxc: No, ^^ eyes are happy. :)
<2> frostbite: You're in a better position than I am to test that!
<12> ah
<2> O_o is boggling eyes
<2> >_<, not so happy
<2> ( -.=)/~ ---====* ( ( (((( -.-) is a ninja throwing a throwing star at another ninja who is running away
<16> mendel, ok - what sort of size would a select * query be from a 10 column table with 2000 rows?
<12> hahaha
<2> frostbite: Seriously, I have no idea
<2> You have the equipment to try it and see
<6> mendel, lol...
<6> mendel, Geez, you don't know? Are you a newbie?
<2> zxc: http://club.pep.ne.jp/~hiroette/en/facemarks/
<2> "How big is a hole?"
<6> Three feet in diameter.
<12> Ah, Japanese emoticons.
Return to
#mysql
or
Go to some related
logs:
+ubuntu video authoring
ktorrent cannot open permission
#nvidia
jmax build dapper
group concat in sql access
gentoo TTF_RenderText_Solid
#perl
menuconfig 915G debian
#oe
#css
|
|