#mysql
01 January 2008
Total 13 pages. You are browsing page 4/13.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
05:28 <****> appy new yea!
05:35 <****> what is the point of storing session data to a db if i can just store post data to the db?
05:38 <****> sometimes the post data contains sensitive stuff
05:38 <****> but a sessionid is one small piece of data
05:38 <****> post vars are large chunks
05:39 <****> so that's probably the primary reason.
05:49 <****> understood pkunkra
05:54 <****> pkunkra: Is there an easy way to transfer session data through a whole form without using a database?
05:55 <****> i know another way of doing this is using hidden input fields for the session data on every page but that's not the easiest way
05:55 <****> is there another way to do so?
05:56 <****> the session data travels to the second page however when the finish button is pressed and there are errors the session data is deleted.
05:57 <****> you can use your programming languages session system
05:57 <****> like PHP $_SESSION
05:59 <****> Pyramide: the problem with that is when the next form page is validated it removes the session data
05:59 <****> :(
06:00 <****> i'm assuming that session data is only stored for the first page transaction
06:00 <****> what language are you using then
06:00 <****> session data should not be lost unless you explicitly delete it or the session is terminated
06:03 <****> happy new year to those in eastern US timezone!
06:05 <****> happy new years
06:05 <****> not sure what you're asking ding0
06:05 <****> here it's 6:00 already
06:05 <****> (germany)
06:06 <****> happy new year!
06:06 <****> Pyramide: what is the best practice when starting sessions
06:07 <****> for some reason when i don't start the session on the second page of the form it shows the session variables which are stored
06:07 <****> depends on the language
06:07 <****> php, servlets, jsp, ruby, perl, ...
06:07 <****> then when i press the submit button the session is no longer filled
06:07 <****> php
06:07 <****> you probably forgot session_start()
06:09 <****> for some reason i used session start and it was not printing the sessions data from the previous page
06:09 <****> but let me try this again
06:09 <****> you need to use it on every page
06:10 <****> and iirc there was session_begin() or so
06:10 <****> haven't used the php built-in session system for years
06:10 <****> Hi. I have many queries stuck (for over 20+ hours) in the "end" state on ndbcluster. Any way to figure out what the heck its doing?
06:10 <****> maybe you should ask in #php
06:11 <****> everyone is busy in there :(
06:20 <****> ding0, so you think #mysql is less busy? :-
06:22 <****> yep
06:23 <****> you obviously haven't met very many dba's.
06:23 <****> all you see in php are quits and joins and no php people speaking
06:24 <****> i'll just use the database to store the session data :)
06:24 <****> ah... that's 'cause the php programmers are allowed to leave their desks. us dba's are chained to our computers and not allowed to leave. :-D
06:25 <****> ding0, sure. that'll work.
06:25 <****> but that's unecessary :( because i'm only trying to hold 4 pieces of data
06:26 <****> i'll use the hidden input fields across the form because it's a small registration form
06:26 <****> for something larger i'll resort to storing the session information within the database
06:28 <****> dumb question. is there a way to find unused id's in a table,say i have a table with a column that has the values 1,2,4,5,6, is there a way for mysql to tell me that 3 is unused?
06:39 <****> |NSA|: probably... but if you are depending on ids to be sequential without gaps then you are probably doing it wrong
06:40 <****> i dont rely on them
06:40 <****> but i have maintinence script tht deletes inactive users after x days, so then google hits their user pages, and gets 404's, so instead, i thought i would just fill in the gaps
06:41 <****> anyone: how do i get mysql to allow remote connections?
06:41 <****> remote
06:41 <****> remove bind-address= and skip-networking from my.cnf and grant permission to the external 'user'@'host' and remove any firewall rules blocking port 3306 and make sure no overrides on the mysqld commandline
06:42 <****> ToeBee: that was a super fast response, do you have some kind of script to type that out for you?
06:42 <****> or is that a bot?
06:42 <****> the_wench is a bot, yes
06:43 <****> the_wench: so i have to specify the hosts i want to allow?
06:43 <****> |NSA|: anyway... why not have your maintenance script just put in dummy data instead of deleting it?
06:44 <****> jodo: you can use wildcards in the host string but it is better to restrict it as much as possible...
06:44 <****> probably right
06:45 <****> '0') group by f_dev_autoid , its takes about 10 secounds to retive answer, is that not kinda slow? is there a way to make the query faster?
06:47 <****> martzipAN^: are the columns indexed?
06:47 <****> i did yeah
06:47 <****> in php my admin i clicked on index
06:48 <****> on all the fields (cause in most of them im doing searching)
06:48 <****> |NSA|: but if you really want to do this... I'm thinking something with a self join. Maybe something like: select t1.id+1 from table t1 left join table t2 on t1.id = t2.id+1 and t2.id is null
06:49 <****> ToeBee: thanks
06:49 <****> err
06:50 <****> that wasn't tested at all... hope it works for him
06:51 <****> got a clue?
06:53 <****> looks like you don't have a very good join condition
06:54 <****> do an EXPLAIN on the query and look at what keys it is using
06:55 <****> what should i see there?
06:55 <****> i did and i see many fields... what should i look for
06:56 <****> there is some fields with key "MUL"
06:58 <****> well usually you want things in the "key" column
06:58 <****> this means it is using an index
06:59 <****> you can put the output up on a pastebin
07:01 <****> im using client
07:01 <****> is there a way to dump it out to file?
07:02 <****> can't copy/paste it out of the terminal? an explain shouldn't give that much output
07:02 <****> ill send you screenshot
07:02 <****> ok?
07:03 <****> well I'm actually about to head out... a pastebin will let others in the channel help if they are still here
07:05 <****> ok tnx anyway
07:35 <****> are there any mysql functions that will parse a comma delimited list stored in a field?
07:40 <****> that's what php is for
07:42 <****> it won't let me put php in a stored procedure
07:42 <****> GOVERNOR ROMNEY: "And further, if I were fortunate enough to be elected your President, I'd call for a National Summit of Nations to create a new partnership – a Partnership for [Progress] and Prosperity."
07:42 <****> "This Partnership would assemble the resources of all the nations of the world to work to assure that Islamic states that are threatened with violent Jihad have public schools that are not Wahhabi madrasas; that they have micro-credit and banking, the rule of law, human rights, basic health care, and competitive economic practices." (Governor Mitt Romney, Remarks At Yeshiva University, 4/26/07)
07:46 <****> is this valid
07:47 <****> insert into table select name,price,NOW() from table2
07:47 <****> where column3 in "table" is type DATE
07:48 <****> sure. should b
07:48 <****> k cool
07:49 <****> orly
07:50 <****> YA RLY
Total 13 pages. You are browsing page 4/13.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last