#mysql
19 October 2007
Total 26 pages. You are browsing page 4/26.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
01:21 <****> thats what I thought. Its driving me nuts.
01:21 <****> change NAME, TABLE, COLUMN and you are good to go
01:22 <****> well i suppose you need not change NAME but it might confuse someone later if you don't
01:22 <****> oh no!!!!!!!!!!!!! I see the problem. I had the name in the wrong ******* place :(
01:22 <****> aargh. tired eyes.
01:22 <****> rgr: :)
01:22 <****> Does the mysql user by default have a password?
01:22 <****> thanks. Sometimes to have someone calm at the other end wakes one up a bit :)
01:22 <****> rgr: lol
01:22 <****> w3: os user? or mysql root user?
01:22 <****> w3 gnope
01:22 <****> it happens to all
01:22 <****> Sorry, mysql database user
01:23 <****> w3: root doesn't
01:23 <****> Maybe I'm not quite understanding it
01:23 <****> really I have been at this for about 2 hours!!!
01:23 <****> Oh
01:23 <****> Sorry, chadmaynard
01:23 <****> I got myself confused, all cool.
01:24 <****> I am perpetually confused. don't worry.
01:31 <****> Hi, I am having stability issues with mysql-5.1 is there any outstanding issues?
01:31 <****> as in the server goes down
01:32 <****> as in the process is on but the socket file gets removed
01:33 <****> and if I connect to the db I get no databases
01:35 <****> can i have a logfile per database? or per user? instead of only one big logfile?
01:35 <****> How does MySQL make money as a corporation?
01:35 <****> services
01:35 <****> sell enterprise edition
01:35 <****> etc
01:37 <****> What benefits does the enterprise edition actually have?
01:38 <****> There's a nifty web page that explains all its benefits
01:38 <****> I saw that, wasn't very clear IIRC
01:38 <****> I'll check again, I would only have briefly skimmed it at the time
01:40 <****> seekwill, it's all business buzzwords bullshit.
01:40 <****> bullshit bingo!
01:48 <****> hi
01:48 <****> can I concatinate verticle columns into a single rows return?
01:48 <****> is there a favoured pastebin for this channel?
01:49 <****> like: select id, join( '|', something ) from somewhere group by id;
01:49 <****> where multiple returns would get contatinated by pipes
01:49 <****> i have a question with the configuration of innodb engine, some body help my ???
01:49 <****> *me
01:49 <****> row1: 123,'blah|blah|blah'
01:49 <****> row2: 124,'john|jane'
01:49 <****> GROUP_CONCAT
01:49 <****> kkruit : tyvm
01:49 <****> @ prakriti:
01:50 <****> prakriti: i understand you want to join fields of same row - concatenate(field1,'|',field2,'|',field3)
01:50 <****> no myrth
01:50 <****> ok then
01:50 <****> :D
01:50 <****> sometimes reading between lines doesn't work :\
01:51 <****> if i specific in the my.cnf the "innodb_data_file_path = /dev/sbd1|:145Gnewraw"
01:52 <****> could some kind soul please check this link and tell me what the syntax error is by ".createdd=now();" is. http://mysql.pastebin.com/m5e8e771f
01:54 <****> do i have mounted my hard disk when innodb use RAW ???
01:54 <****> or not is necesary ??
01:54 <****> "innodb_data_file_path = /dev/sbd1|:145Gnewraw"
01:54 <****> "innodb_data_file_path = /dev/sbd1:145Gnewraw"
01:54 <****> some body help me ??
01:54 <****> you are too impatient
01:55 <****> sorry :$
01:58 <****> also, should I ever get my simple trigger working, what, if any, perofrmance hit would I get on a "before insert" trigger which doesnt alter other tables?
02:03 <****> is this link till up? Sorry if so.
02:08 <****> where are the databases which are being replicated defined?
02:08 <****> (MySQL 5.0)
02:09 <****> Hi!
02:11 <****> mysql. The access from tomcat to the database is very slow. When i use phpmyadmin and look at the processes (show processlist) i see tomcat connecting. The user is "unauthenticated user", the state is "login". This takes up to 10 seconds and then the user switches to the real user.
02:18 <****> if I do a joing
02:19 <****> join, can I select sometable.*, anothertable.field ?
02:19 <****> like all fields from one and selective fields from another?
02:21 <****> I am attempting the syntax I just wrote right now, its just a HUGE table so its taking a while;
02:22 <****> Lol.... you know you have been coding too long when you start ending sentances in ";".
02:23 <****> lol
02:23 <****> Yay! It works!
02:24 <****> is there a way to get phpmyadmin to continue an import after errors?
02:26 <****> ah ok, so if I want to add a new db to replication, what's the process? stop replication, add replicate-do-db to slave's config and restat mysql then restart replication?
02:27 <****> seems it was the problem with skip-name-resolve
02:27 <****> so my problem is solved :-)
02:27 <****> Is it possible to count the number of rows returned by a subquery?
02:32 <****> hi all.
02:32 <****> Is there a way to count the number of rows a query would return without actually returning the entire resultset?
02:33 <****> need some help, i have a client with a database containing BLOB info, I do not have access to a command line so i cannot use MySQLDump on it.
02:33 <****> When I export with PHPMyAdmin the BLOB data is lost, is there any other way to obtain the data?
02:40 <****> voxia, get another machine with a commandline, give it access to the db, then dump it that way
02:41 <****> I have a table, and the primary key is made of two fields. pri_id, sec_id
02:42 <****> I want a select that returns only 1 row for each pri_id and the max() of sec_id
02:42 <****> its a revision system basically
02:42 <****> i'm trying to make a view
02:42 <****> i can do a select that uses a subselect
02:42 <****> theBear thanks
02:43 <****> group by doesn't work because the data is different from row to row
02:43 <****> the only way I can get around it is by making two views
02:44 <****> one view that simply returns my pri_id and my max(sec_id)
02:44 <****> but I would liek to make a single view if possible
02:44 <****> any ideas anywhere?
02:45 * seekwill is in a Thug-life
02:45 <****> theBear what specific mysqldump option do i need to use
02:45 <****> to get the BLOB data?
02:46 <****> Thug life was a rap group, before you start
02:46 <****> prakriti, that sounds like it would best be put in two tables.
Total 26 pages. You are browsing page 4/26.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last