| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Comments:
<0> will: well, I just didn't expect to have to dump the mysql schema too to do it.
<0> (I admit, I'm a mysql hater) I'm used to Postgres when you dump, you get all the GRANTS too, it's not in another schema
<1> What you are asking for is a "point in time" info. Your original GRANT may not be what it is currently.
<0> curious.
<1> Because you could make other modifications, directly to the mysql.user table.
<1> MySQL, or any other application, would have to create a new GRANT
<2> hi
<1> ho
<0> well I don't exactly love that you can do that either, but a valid point.
<0> so if/when I load the mysql schema from a dumpfile, I just have to do a Flush privs right?
<0> and then I'm all good?
<1> Can't love anything 100%, not even your wife.
<1> Yep
<2> so i have a table w/ phrases in it that i dont want duplicate phrases in, would it make more sense to verify the phrase is unique in PHP? or make the field unique in mysql?
<1> Not too hard.
<1> acidjazz, Both
<1> I prefer to have PHP check. To save a trip to the DB.
<1> Err
<0> cool. I think I now have enough to fully-script a replication slave bringing itself up from ground-zero
<1> I prefer to have PHP check. So I don't have to have "errors" in key violations.
<1> MyQuiL, Nice :)
<1> I really need to start using replication.
<0> will / acidjazz : Proper DB theory should say soemthing like the DB engine can always do things more efficiently than your application code can
<0> will: it's about 6 lines of SQL to do it.
<1> To do what? Check the DB? or replication?
<0> I'm setting everything up here so that the nodes all come up with id=1 and read-only, and then via scripts you tell it what id and role it will have
<0> replication, much simpler than the dox
<1> That's nice
<1> I've never needed to use replication. Even now. But I want to try it out.
<0> well our experience with clustering for horrible. damn thing would just make the schema disappear after a while.
<2> i guess text fields cant be unique?
<1> Definately not need clustering... heh. If our business needed that, I would be able to hire people to implement it.
<1> acidjazz, It can. Just the first part.
<1> That's a lot of work for a DB to check 65k characters to see if it already exists...
<3> is there a way i can get mysql to not transmit in gzip
<1> It transmit in gzip?
<1> When?how/
<1> ?
<3> 10.40.1.3:3306 -> 10.40.2.2:53273 [AP]
<3> ....]..x..T[O.A.=?m??V...?Z.?rQ...|?
<4> pull the plug on the mysql server. then it won't transmit in gzip anymore
<5> hello! i have a table with 4 rows, and am doing a query with its conditions etc... but i want to avoid to get results which have the same value in a specific row... how do i specify that in the query?
<3> Hal9002: distinct(rowname)
<6> albo: MySQL uses its own protocol, not necessarily plain text. You can't read a MySQL session by looking at the tcp stream.
<5> thanks :)
<1> Are you sure that is Gzip?
<7> why is albo ***uming that is gzip
<1> Should be binary... like it's log.
<8> he speaks gzip but not fluently
<1> I honestly thought it would have been cleartext...
<1> Except for authentication.
<4> who is MyQuiL?
<8> albo: how are you talking to mysql ?
<8> it's yourQuil
<1> That guy.
<6> I took a course to speak gzip once, but they really crammed too much into the available time, so I didn't get much out of it.
<4> yeah
<3> YourSQL
<1> mendel, lol
<8> mendel++
<0> (I just thought it was fair)
<1> ok
<9> hello there, I'm currently working on a shop solution. The shop consists of 3 different product categories(books, audiobooks and software). The product table contains all attributes which are the same on all those 3 different categories. The books, audiobooks and software table contain specific fields for that category. Now, I want to make a statement which gives me actually, depending on the category, all details for a product. (will continue..
<8> looks like homework to me
<6> will: go ahead, continue
<9> now, would you guys go thru each categories and pick out the fields or would you make a big join statement, joining somehow all 4 tables together?
<5> albo: can i make a combination of two columns distinct?
<9> to me, it seems like I would have to go thru each category seperatly because the big join statement recordset wouldn't look so nice because it would have alot of empty fields.
<8> hopefully no arrest warrants
<10> I'd store the sub-type records in a LONGTEXT on the products table in gzipped CSV format
<7> I did that once and found myself as an author
<1> mendel, With?
<4> hmm
<10> albo can help you with the gzipping part
<8> lol
<6> will: ndee asked you to continue up there. :)
<9> sjrussel: would you in general not split up the different categories onto different tables?
<9> mendel: lol, nah, I meant to write "will continue with writing"
<6> I know :)
<9> sjrussel: ah ;)
<4> nothing too interesting
<9> kk, my sarcasm/whatever-meter needs to be recalibrated,
<4> couple hits on blogs, a couple random sites of mine, and the rest irc logs
<11> is there a way to do a WHERE clause that uses IF ?
<2> how do i do something like this :
<2> UPDATE salesrep a set a.group_id SELECT b.id from salesrep_group b where b.name = a.company_name;
<9> I think I will go thru each category. I need to output it in an email
<1> mendel, oh lol...
<12> Hi all, I have a real newbie question and problem.
<13> mendel: Don't know if you remember, but I asked you earlier today about my /var partition being almost full.
<4> SELECT * FROM foo or die("Query failed");
<13> I ran lsof as you recommended and it showed some ~250 instances of mysqld.sock open.
<13> After hours, I did a soft restart of the mysql daemon and it instantly cleared up the problem.
<12> I was having a problem with an 4.1.12 install and updated to 4.1.18 but didn't export the db
<12> now I can't access it.
<1> Error?
<12> I'm on OS X and the previous install with data folder is there
<13> Any ideas why running mysqld for awhile without restart would cause the sockets (or whatever) to begin to eat up disk space?
<6> tocano: You saw one per thread, but that wouldn't have been what took up the room -- one of those must have held open a big temporary disk table or something.
<12> how do I import the old data
<6> Woos
<6> Also: Woops
<1> afragen, The upgrade should have been seemless. Should have worked. What is the error message?
<4> Woo? Who?
<6> When mysql needs to do temporary operations on disk, it creates the file and immediately unlinks it, so it just has an fd open to it
<6> That makes it really hard for something else to delete :)
<12> no error message, but the old databases aren't present
<13> ahhh
<6> But it also keeps the space occupied until the fd is closed
<6> When you look at mysql in lsof output, though, keep in mind that each "process" is just a thread of one process
<13> right
<6> (which explains why it looked like there were a lot of sockets open)
<13> Well, apparently, over long enough period of time, those add up ... significantly
<9> afragen: someone's hungry...
<6> tocano: MySQL doesn't (well, shouldn't) hold them open when it's not using them, though.
<1> What a girlie.
<12> hungry?
<13> mendel: Well, I am still on 4.0.22, so maybe it's a small bug.
<9> afragen: it was just a bad joke
<12> no problem
<13> mendel: Either way, thanks for the direction. That helped me find it.
<6> np
<12> so, how do I restart the mysql server to point to my old data folder?
<1> afragen, Edit the my.cnf file.
<12> will: I know I can find the my.cnf file but what precisely are the edits I need
<14> how do i do string concatenation in a mysql query
<12> will: currently my.cnf has
<12> http://rafb.net/paste/results/u1NVE454.html (4 lines of Plain Text)
<12> brb
<14> such as SET options.option_value='http://demo.lyceum.ibiblio.org/' . blogs.slug
<14> i'm guessing it's not a dot like in php...
<1> datadir?
<1> !m jjb_lyceum string functions
<15> jjb_lyceum: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<14> will: thanks
<14> brilliant.
<12> back
<1> front
<16> is there anyway to run mysql commads from a bash shell?
<1> Yes
<16> oh?
Return to
#mysql
or
Go to some related
logs:
all-eye installer
centos dedicated epassporte
ubuntu hpt374.ko
aochat python
#css
#oe
aoss not working dapper
#lgp
#php
#perl
|
|