| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> pCarsten, you told me REPLICATION SLAVE is the priv to do start and stop slave, the ymsql manual says that there is super-priv needed for that
<1> pCarsten: Thanks I guess I was over-simplifying there, I'm trying to do a subquery without using a join.
<2> hackel: why?
<3> hackel, subqueries have been known to cause boils and warts if used incorrectly
<4> hackel: ELECT * FROM xint WHERE (val,uint) IN ((10,10))
<1> pCarsten: my own curiosity? :) I mostly use this stuff when exploring data (just wanting to compare two sets to see the differences between them) when it is adventageous to keep the select statements as they are in the code.
<4> hackel: Sorry. That was a SELECT.
<4> hackel: You can test tuples just like that.
<1> Xgc: Bah, thank you that was too easy. I tried that just forgot the first parentheses. :-/
<4> You're welcome.
<5> is there some kind of full text search functions for innodb table types?
<2> Snadder: LIKE :-)
<5> pCarsten, but I whould like some kinda rating.. of how good a column matched my search.
<2> Snadder: I know, 'twas a joke. No, InnoDB does not have FT indexing
<6> store what you want in a myisam table
<7> Do like the sample database. Store the data in an InnoDB table, and use triggers to clone the texty parts to a MyISAM table used just for fulltext searching.
<5> mhillyer, which sample database?
<5> I guess I need to do it like that.. even if its a hack.
<7> Which sample database? The Sakila sample database, of course!
<7> It is an elegant hack ;)
<8> mhillyer, Snadder: yah, I'm a fan of that too, because I run the text columns through a 'sterilizer' that removes HTML and a bunch of other words
<7> Which I should be working on instead of watcing this channel.
<9> back
<9> anything interesting happen while I was gone?
<3> cj, nope
<9> that's too bad :)
<8> cj: hundres of children died of starvation?
<9> Jivedue: :(
<8> Snadder: why don't you just store the tables as MyISAM?
<5> Jivedue, because I have maybe 15 tables which relate to eachothers.. I dont want to use client code for making sure the relations is like they should be.
<8> like me? haha
<5> Jivedue, if i'm going to use myisam.. without relations.. then it whould feel like going back to the stone age.
<9> Snadder: ah, foreign key enforcement...
<9> Snadder: how's that working for you?
<5> cj, working greate
<9> Snadder: good to hear it!
<5> but had a few problems before it was working correctly.
<9> Snadder: did you blog them for troubleshooting purposes? :)
<9> Snadder: would you if I asked nice?
<10> im lost in my db :( can this Author/Things (Books, CDDVD, Article) relationship somehow work? http://home.pages.at/metalfan/
<8> I don't see what the big deal is, you just insert multiple rows at once, in your app, and delete multiples at once, or just prune later
<9> Jivedue: what happens if the power gets plugged on your app's machine when it's half-way through the operation?
<8> I'm not suggesting you go from InnoDB to MyISAM, I just don't think that fk constraints are really that much of a plus
<10> *constraints are a hell of a feature if youre a teacher thats used to access ;)
<7> There are those who would kill you for saying that Jivedue.
<9> Jivedue: to each their own. it's good that MyISAM works for you. InnoDB works for others. :)
<8> well, I like that MyISAM selects one hell of a lot faster
<9> Jivedue: yeah, that's the benefit of doing everything at the application level
<9> Jivedue: but to some folks, speed isn't everything
<7> Then there are those who would kill you for sleeping with their sister.
<9> robustitude is worth the trade-off
<8> how about those that would just kill you .. for no reason
<5> cj, I guess I can show you how it works.. but not untill after the project is done...
<11> insert into users (`access`) select user_lastvisit from phpbb_users <-- this reports: #1062 - Duplicate entry '0' for key 1 . anny tips appreciated.
<9> Jivedue: they'd argue that there was a reason :)
<9> Snadder: sounds good
<7> You mean the Illuminati? We do not speak of them outside of private messages Jivedue.
<8> btw. it's fine by me, if the app dies
<9> redduck676: unique key overlap
<12> what means n:m relation? n:n? etc...
<8> you just have to be careful how you program the inserts/ deletes
<9> turbano: need context
<8> really all you ahve to do is make sure you do it in the right order
<5> mhillyer, ok.. so you think its possible to duplicate maybe 5-8 tables.. with triggers.. from innodb tables to myisam tables.. and make sure everything is updated when I delete/insert/update the real database?
<11> cj: stupid question: what does that mean? how can i get it to work?
<8> Snadder: don't duplicate teh whole table, just the fulltext columns
<13> if i backup just the MySql\data folder do I loose anything? is it better or worse that running a dump operation? the database is read only
<7> Snadder: Already happens in the sample database.
<9> redduck676: not such a stupid question. that means that you've defined a column as a unique (or primary) key, and that you're trying to insert a row that duplicates an existing row's unique col value. follow?
<12> cj -> relationship between tables
<9> redduck676: do you know how to use http://rafb.net/paste ?
<7> Jivedue: You talked to Snadder? I'LL KILL YOU!
<9> redduck676: if you can figure it out, then issue this command and paste the result there:
<13> easy there
<8> mhillyer: what is behind this nick is an idea. Ideas cannot be killed.
<13> no ones going to get killed over a relational databasw
<9> mysql> describe access;
<9> mysql> describe phpbb_users;
<5> mhillyer, ok.. i'll check that database.. if I find it..
<6> syntaxs error redo from start
<7> Snadder: http://www.openwin.org/mike/index.php/archives/2006/03/sakila-07/
<7> mallard: The database wars have begun.
<11> cj: i will paste that here, instead of pastebin-ing it: DESCRIBE access;# Rows: 4
<11> DESCRIBE phpbb_users;# Rows: 52
<14> metalfan_: uh, you didn't like my earlier answer?
<14> metalfan_: you'll need a third table.
<10> Duesentrieb, im new to dbs....just learned the fk feature...
<11> cj: (btw access is a column in users)
<13> if i backup just the MySql\data directory how do i recover the database? Does it have to rebuild all the indexes?
<11> and users != phpbb_users
<10> Duesentrieb, theres one, in the right corner....books of authors ?
<9> redduck676: ah. then please describe phpbb_users and users, and paste the output to a pastebin
<10> Duesentrieb, authors of books i mean...not what you have in mind?
<14> metalfan_: "right corner"? or what? Well, "authors of books" sounds like a reasonable name for that table, yes (besides the spaces, of corse).
<14> i have no idea what you are looking at, though
<7> He's looking at the right corner.
<10> http://home.pages.at/metalfan/
<14> apperently
<11> cj: http://pastebin.com/662111
<10> Duesentrieb, thought you awnsered because you saw that picture... ;)
<14> metalfan_: yes, that's it - although that table should not have an identity column.
<9> redduck676: that's not at all what I expected :)
<14> metalfan_: (actually, it has a composite primary key that consists of all two fields - but don't worry about that)
<9> redduck676: what are the tables you are trying to select from and insert into?
<15> perror 2
<15> oops
<15> !perror 2
<16> System error: 2 = No such file or directory
<10> Duesentrieb, thx, *testing*
<10> alter table Copy drop column `Authors of Books`; <- whats wrong with that, beside the table name
<13> what is the difference between the MYD and MYI files?
<11> cj: i installed drupal and than took some of the phpbb columns (from phpbb_users) and inserted them into the drupal's table. now i found out that there are some colums i can 'port' to drupal as well and i am wondering if there is a way to do it witout deleteing everything that i don`t need from phpbb_users
<6> one is data the other is index to the data
<14> metalfan_: that table does not have a field called "Author of Books"?
<14> (field == column)
<12> hi guys
<12> i'm trying to figure out what is 1:n and what is 1:n(non-identifying)
<3> can anyone tell me what's wrong with the FKCs here on line 117 and 118: http://pastebin.com/662122
<12> i know that 1:n = 1 to many...
<13> so if i back up the MYI files will MYSQL complain if I recover them or will I have to rebuild them?
<10> Duesentrieb, | Authors of BooksIdentity | int(11) | YES | MUL | | |
<10> ah..never mind
<14> metalfan_: in what table? You where trying to drop it from the "Copy" table...
<13> it looked to good in the brochure
<10> its a forein key in the copy table...
<3> mhillyer, cj, any ideas on why my FKCs fail here: http://pastebin.com/662122 ?
<13> I think there should be some My Sql babes
<7> Here being where?
<3> when i uncomment the FKCs it fails, when i comment them it works
<3> mhillyer, here being the paste i pasted
<7> mallard: You find them, I'll arrange the calendar shoot.
<7> Where in the paste, which FK?
<3> mhillyer, lines 117 and 118
<3> mhillyer, as i already said
<3> :)
<7> I saw no line numbers when you binged me.
<7> Anyway, what does SHOW INNODB STATUS say?
<3> mhillyer, i don't think i have access to that, i don't have root access, it's a shared host
<3> mhillyer, i beleive i already tried that once but i'll try again
<3> ERROR 1227 (HY000): Access denied; you need the SUPER privilege for this operation
<13> mhillyer: they should be in swimwear with dry erase markers drawing relational diagrams all ***y, you know?
<7> r0xoR: Nevermind.
<3> k
<3> i mean the FKCs *look* right to me... but it's obviously failing
<7> FK definitions go after the column definitions.
<3> mhillyer, huh ok
Return to
#mysql
or
Go to some related
logs:
#web
Realtek PHY RTL8201CL debian
#centos
#web
bllell
gam_serve disable
#fluxbox
how new yahoo mail
upgrading udev from terminal
#fedora
|
|