| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8
Comments:
<0> with MySQL on another one, one the local LAN only
<0> so web server can access it, but nothing else
<1> I'd like to see you put apache on one machine and php on a different one. ;)
<2> oh i am sure it can be done
<0> RainMkr: frequently done in commercial sites
<0> not even anything unusual
<3> alrighty, im back in business, thanks again Sneaky_Bastard
<4> [RainMkr] is that a challenge?
<0> welcome mxktmdude
<1> rioter: For anyone but you.
<4> haha
<0> rioter: php mySQL module doesn't care where the server is
<0> as long as it has a hostname, portnumber, login and p***word
<4> Sneaky_Bastard hes not talking about the mysql module
<1> rioter: Knowing you, you'd do something goofy like calling PHP as a cgi to a remote server via ssh.
<0> hostname or IP address
<1> rioter: thereby proving it *can* be done, but gaining *nothing* useful in the process.
<4> [RainMkr] isnt that what open source is about?
<0> Apache + PHP on one machine and MySQL server on another is *nothing special* and requires *no special effort*
<0> >:(
<4> Sneaky_Bastard *your* mi*ssi*ng the *point*
<0> no, you are. There are n00bies in this channel and your people's joking around is giving them false information.;
<0> >:(
<5> after I've created an index is that it?
<5> the index then just makes my WHERE clauses faster on that column of that table?
<4> Sneaky_Bastard are you my boss? cause you sure act like him
<5> or do i actually run select queries on the index
<1> r0xoR: Maybe. Depends upon how useful the index is.
<5> or is there a special index query... or what
<1> LoL!
<6> so you're saying mysql is hard right rainmaker ? and php is even harder ?
<5> [RainMkr] heheh, ok so how do I figure that out?
<0> I don't sign your paycheck, so I'm probably not your boss
<1> alphablue: damn near impossible for me. I really don't get either one of them.
<0> one can never quite be sure, however.
<4> im glad i dont get a paycheque
<5> !man index
<7> (Index Preloading) : http://dev.mysql.com/doc/mysql/en/Index_preloading.html
<8> hrm, no-one has any ideas viz recovering lost table entries?
<8> I have .BAK files ...
<1> !man explain
<7> (EXPLAIN Syntax (Get Information About a SELECT)) : http://dev.mysql.com/doc/mysql/en/EXPLAIN.html
<2> i find that money appearing in my account by magic each week is a satisfactory alternative to a paycheque
<4> [RainMkr] gnome-vfs would make it easy as well
<5> !man indexes
<7> (Column Indexes) : http://dev.mysql.com/doc/mysql/en/Indexes.html
<4> im going to submit my idea to slashdot
<4> see if i can convince people to start doing it
<4> mmm
<1> rioter: I thought crack cocaine was like firearms down under... outlawed.
<4> wonder how slow it would be hosting it on a remote server using nfs
<1> via a smb interface!
<4> haha
<4> and just to be secure
<4> every time a page is requested
<4> php is recompiled
<4> i see this as the future of webhosting!
<9> what command can I use to export my MySQL database for backup purposes?
<10> mysqldump, mysqlhotcopy
<9> from my shell account
<9> whats the diff?
<10> I have no clue. But the Mysql docs say that hot copy may be better.
<11> is it possible to get any OS level performance stats from within MySQL?
<11> such as system load...
<1> burtonator: No.
<12> Silly style question: Should table names and column names be plural or singular? Or plural for tables, singular for columns?
<13> peqe: singular for tables if what I've heard. plural for columns would typically imply that they aren't designed properly as you wouldn't want more than a single thing in a column anyway
<13> s/if/is
<14> if i have a table with user info, then another table with the user's profile information, how can i make it so the primary keys for the tables automatically match up for linking purposes?
<13> they won't automatically match up without you inserting the proper data. You can enforce that you don't have mismatched entires with Foreign Key Constraints. Use InnoDB if you need FK constraints
<15> wikki wikki wiki
<16> hey
<16> I am looking through a cl*** that a friend of mine gave to me for mySQL queries. lots of the functions like mysql_pconnect() have an @ in front of them. What does that do? I tried searching the documentation but couldn't find anything for some reason.
<17> Anyone here use SQLyog?
<18> what's mysql default behaviour when you try to add a value to a unique field, which is already contained in another record of that field... ?
<19> no thanks
<19> did you even try it in a test table babo?
<20> i installed mysql stable, and out of nowhere now, i am getting this error when i try to connect to mysql: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
<18> lwh: well if I tried it on a test table I wouldn't be asking the question now would I ? ... I don't have mysql on the computer I'm working on ...
<21> can anyone recommend a good SAN vendor?
<22> Why the heck isn't this query working?
<22> select *from sections where section like '__' and not like 'b_';
<22> Seems reasonable
<20> i installed mysql stable, and out of nowhere now, i am getting this error when i try to connect to mysql: 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"
<23> htns> What's the error?
<22> Never mind, I got it.
<22> It says invalid mysql query
<23> htns> I take it you seperated the * and "from".. select * from ... in stead of select *from ?
<22> No, I just did mysql select * from sections where section is like 'a_'
<22> Instead of not like 'b_' since I just wanted like 'a_'
<23> Ok.. try this first
<23> select * from sections;
<22> Well I mean, that'll get all of them
<22> It works, if that's what you know.
<23> Ok
<23> Then try this:
<22> But my problem was that "mysql select * from sections where section is like '__' and not 'b_'" does not work
<23> select * from sections where sections is like 'a_%'
<22> If I remove the words "and not 'b_'" the query works.
<23> ah duh
<23> I missed that thanks
<22> * I meant, "and not like 'b_'"
<22> Ah, np, thx for trying help. (-:
<23> select * from sections where section is like'__' AND section is NOT like 'b_'
<1> SELECT section FROM sections WHERE section LIKE '__' AND section NOT LIKE 'b_';
<23> duh
<23> I'm gonna go to bed :D
<23> thanks [RainMkr] :)
<24> is it possible to track product going through three processes using one table?
<1> jason_: eh?
<24> long tube are come in and the tubes get (1)cut and (2)deburred and (3)cleaned. could i use one table to track the part?
<1> sure.
<1> ALTER TABLE foo ADD tube_status ENUM( 'cut', 'deburred', 'cleaned' ) NOT NULL;
<24> let's say there is a rejection (yikes) a year from now. i need to find out who cut the tube and what date it was cut. that is possible with ONE table?
<1> probably.
<1> ALTER TABLE foo DROP tube_status;
<1> ALTER TABLE foo ADD cut_by SMALLINT UNSIGNED NOT NULL, cut_date DATETIME NOT NULL, debur_by ...., debur_date ...., clean_ .... ;
<24> when the raw material comes in, i want the cutter to be able to use his cursoer and 'point' to the raw material so it can be tracked throughout the process. is that possible?
<1> I suppose if there is a barcode or rfid on it.
<24> so your coding is having the operator munch in his name or employee code each time he starts to cut or deburr?
<24> munch=punch
<1> or you track that in some method.
<1> That's application/process related, not really DB related.
<24> this is interesting..maybe i could have the operator select from a pre-existing list..like a combo box or something..like he selects his name, the customer, the part number,..etc
<1> Sure
<24> i HAD all the processes from incoming to cutting, deburring, cleaning and shipping in seperate tables, but i gotta do the whole thing over cause my system is messing up
<24> suddenly, i am getting the 2002 error and i am dumbfounded
<25> question: would decreasing the minimum fulltext keyword length to 1 in order to catch numerals be a remotely sane thing to do?
<1> uberpenguin: I don't think so, but TIAS
<25> TIAS?
<1> Try It And See
<25> of course I would add a bit to the stopword list as well
<25> e.g. the english alphabet
<26> why would mysql 4.1 give this error to all DROP USER queries as root? ERROR 1268 (HY000): Can't drop one or more of the requested users
<25> well, I'm in a situation where I really need fulltext searches to take note of numerals...
<1> pdaX: You haven't removed all privileges from the user.
<25> and failing that idea and/or an ugly source hack, I can only think of duplicating all the text that is searched and changing numerals to their word-equivalents
<1> uberpenguin: Like I said, try it.
<25> yes, well I'm not in a position to try it at the moment since the backup DB server is offline for maintainence
<25> I was just fishing for ideas
<24> is there an easy fix for the error 2002?
<1> that's not a MySQL error number that I'm familiar with. Paste the whole error message here.
<24> ERROR 2002: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
<27> I'm experiencing a bug using PHP5 + MySql 4.1 when doing mysqli_stmt_bind_result
<27> The data is getting all garbled up upon selecting it and printing it to the screen
<27> has anyone else experienced this?
<1> jason_: Doesn't sound like mysqld is running.
<1> lblue: sure it's not a unicode issue?
Return to
#mysql
or
Go to some related
logs:
tvtime cannot open capture device ati ubuntu
#ubuntu
span innerHTML innerText contentText
#ai
Ubuntu vga=771
st_mtime inaccurate windows
lvm ext3 journal abort
ubuntu sharing folders win
Why a Primary Key? MySQL
sid2wav dos
|
|