#mysql
24 October 2007
Total 29 pages. You are browsing page 3/29.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
00:38 <****> Trengo: I'm not sure. what is the proper syntax for Ubuntu?
00:39 <****> JeevesMoss sorry, dunno ubuntu :D
00:39 <****> Is there a way to delete rows with a range?
00:39 <****> google knows, im sure
00:39 <****> JeevesMoss: Hey! I was talking to you
00:39 <****> Like: delete from wp_posts where id='217,218,219,220,221';
00:39 <****> or: delete from wp_posts where id='217 .. 221';
00:39 <****> chadmaynard: sorry, I enabled it
00:39 <****> setuid: WHERE IN IN (1,2,3,,543,2)
00:39 <****> what was the URL again
00:40 <****> www.penn-tawsha.net
00:40 <****> i don't see errors
00:40 <****> ???
00:41 <****> in it
00:41 <****> info.php or something
00:41 <****> shouldnt it be echo phpinfo(); ?
00:42 <****> no
00:42 <****> im not sure ..
00:42 <****> ok then
00:42 <****> chadmaynard: www.penn-tawsha.net/info.php
00:42 <****> JeevesMoss: surely there is no connector
00:42 <****> ??
00:43 <****> JeevesMoss: did you use a package manager?
00:43 <****> JeevesMoss: try: sudo apt-get install php5-mysql
00:43 <****> chadmaynard: yes, apt-get
00:43 <****> then do what Gushie just said
00:43 <****> Gushie: I've done php5-mysql and php4-mysql
00:43 <****> have you restarted server ?
00:43 <****> restarted?
00:44 <****> longin: yes.
00:44 <****> I think it has to be something stupid
00:44 <****> JeevesMoss: it must not have worked.
00:44 <****> chadmaynard: umm .. something wrong ? :.]
00:44 <****> JeevesMoss: is mysql.so uncommented in php.ini?
00:44 <****> I've been trying to figure it out for the majority of today
00:44 <****> one sec, checking
00:44 <****> JeevesMoss: run php -m to show modules, etc.
00:45 * chadmaynard HATES php
00:45 <****> hrm, I hate howtos that include bogus code examples
00:45 <****> http://www.databasejournal.com/img/NB_removedupes_code.html#code1
00:45 <****> People need to try their own code before they post it as a code example
00:45 <****> I uncommented them, and now it wants to d-load a file. WTF?
00:46 <****> thEMOlester ? :]
00:46 <****> setuid: what is the error?
00:46 <****> chadmaynard, Apparently that's not for MySQL
00:46 <****> mysql strips out the #, and doesn't understand what 'begin tran' is
00:47 <****> setuid: just the transaction stuff
00:47 <****> chadmaynard: any other ideas before I go back and yell @ the PHP guys?
00:47 <****> JeevesMoss: install php5-mysql
00:47 <****> chadmaynard: I did
00:47 <****> I'll be fighting this all night, I suspect. Maybe ther'es a better way to bulk delete dupes
00:47 <****> setuid: delete where wp_content = ''; ?
00:48 <****> JeevesMoss: that is an apache problem now.
00:48 <****> you aren't sending .php files to the processor
00:48 <****> chadmaynard: thanks. now I know I've got the MySQL problem solved. Thanks again
00:49 <****> well that was interesting
00:49 <****> chadmaynard, So no way to specify a range for delete? Just manually putting in each row_id?
00:49 <****> delete from wp_posts where id in(130,131,132,133);
00:50 <****> setuid: where 130 <= id <= 133
00:50 <****> setuid: delete from wp_posts where id between 130 and 133
00:50 <****> or id between 130 and 133
00:50 <****> ah
00:50 <****> That'll work
00:50 <****> These are all things I've never had to do before
00:51 <****> Most questions are things that people have never had to do before, otherwise they'll already have the answer :)
00:51 <****> haha, I suppose
01:03 <****> where can i edit the root account of mysqld not to be root
01:03 <****> but something else?
01:03 <****> noob alert. does the mysql server have a default timeout after which idle connections will be cut off?
01:03 <****> CountDown: yes
01:03 <****> _yannick: there is nothing special about the mysqld root user
01:03 <****> CountDown: wait_timeout and interactive_timeout variable
01:03 <****> chadmaynard: that's not true. He has super powers.
01:03 <****> how do I create a user with equal priviliges?
01:04 <****> nils_: thanks. is there a way to set that from the client side or only from the server side?
01:04 <****> GRANT ALL ON *.* TO chucknorris@host identified by 'password' WITH GRANT OPTION
01:04 <****> yup ^^
01:04 <****> except fors nils_ didn't quote!
01:04 <****> bad nils_
01:04 <****> CountDown: I think you can set it on the client for your session, SET wait_timeout = [value];
01:05 <****> wait_timeout is for queries
01:05 <****> not idle connections
01:05 <****> nils_: can that value be zero or someother value to indicate that the connection should remain open until the client closes it?
01:05 <****> ah
01:06 <****> wait_timeout x max_tries = max query time
01:06 <****> chadmaynard: is there a variable for idle connections?
01:07 <****> CountDown: umm. the default is huge
01:07 <****> like 8 hours. You don't want idle connections to live forever.....
01:07 <****> CountDown: I don't think so, you can set it really large...
01:07 <****> CountDown: I think the default is a day or something like that
01:08 <****> hmm 8 hours on my host
01:08 <****> that's 7 hours longer than I even work
01:08 <****> nils_: sounds familiar
01:08 <****> how do i find that out?
01:08 <****> what the timeout is, i mean.
01:08 <****> show variables like '%timeout';
01:10 <****> thanks.
01:30 <****> hi everybody !
01:31 <****> i have problems with the configuration script for mysql
01:31 <****> i have installed mysql from yast
Total 29 pages. You are browsing page 3/29.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last