#mysql
14 October 2007
Total 16 pages. You are browsing page 2/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
01:33 <****> and if smartctl isn't available you can install smartmontools through whatever package manager you're using
01:34 <****> anyway, ask your hosting provider
01:34 <****> http://pastebin.com/m47d91d83
01:34 <****> they'll replace the disk for you
01:34 <****> and prepare to do backups
01:34 <****> its alredy second disk -.-
01:34 <****> going to kill them
01:35 <****> which hosting service is it ? (so I can just avoid them)
01:35 <****> hehehehehe
01:35 <****> skyberate (holland company)
01:35 <****> :p
01:35 <****> wtf? "Power_On_Half_Minutes"
01:35 <****> yes i never suggest to go there :p
01:35 <****> thanks
01:35 <****> who measures power on hours in half minutes?
01:35 <****> Djbaby what server is it?
01:36 <****> http://info.core-server.be/
01:36 <****> complete whatever you need i think
01:37 <****> what kind of game are you hosting btw ?
01:37 <****> is it a dell?
01:37 <****> Djbaby: well according to that smart output that disk has been spinning for over 400 days
01:37 <****> yet uptime is 32 days :p
01:37 <****> no idea Trengo i just rent it :p
01:37 <****> well that is total time that drive has been on
01:38 <****> Djbaby its up to your provider then
01:38 <****> ok i wil call them money
01:38 <****> monday
01:39 <****> no support today? :P
01:40 <****> yes but server runs so its not an emergency :p
01:40 <****> even we give support on weekends :)
01:40 <****> and also 1:42am -.-
01:40 <****> but is the service up?
01:40 <****> silly europeans. It is 6:43 PM!
01:40 <****> i can call them yes but il wake them up :p
01:40 <****> thats what they get paid for :P
01:41 <****> yeah but i doudb the wil go to datacenter now and go fix it
01:41 <****> doubt*
01:41 <****> indeed
01:41 <****> and if it is a dell, they will only open a ticket on monday
01:42 <****> to be honest i have this server for about 2years
01:42 <****> and i still dont even know what it is
01:42 <****> yet i do know its out of dated by now :p
01:43 <****> can you afford an upgrade? :)
01:44 <****> its cheaper if i upgrade then current prize i pay now -.-
01:44 <****> yet it holds me couse of things i have on it now
01:46 <****> though till monday anny tips i can do with hd to minimize mysql errors?
01:46 <****> Djbaby: I was on the phone. Nice drive statistics. :)
01:47 <****> crap i see it to
01:47 <****> How is that system staying up at all?
01:47 <****> its worse then my worst hd on my pc
01:47 <****> no idea
01:47 <****> but i do know i need to fix it evry day
01:47 <****> getting crazy thats why i came here :p
01:48 <****> what kind of game are you hosting Djbaby?
01:48 <****> wow
01:48 <****> World of Warcraft
01:48 <****> hm ok a website dedicated to WoW
02:12 <****> guys i have a dude
02:12 <****> is the same do it: update numer=numer+5 , than : update .. name=name+'fistmame'? i want concatenate words
02:14 <****> hello, how to do hours difference between 2 timestamp taked from 2 different rows?
02:15 <****> !man string functions
02:15 <****> (String Functions) : http://dev.mysql.com/doc/mysql/en/string-functions.html
02:15 <****> DanyWalker: look at that page
02:15 <****> please help
02:15 <****> there is a concat function
02:17 <****> ToeBee, thanks
02:17 <****> is not the problem
02:18 <****> i want update a field, with new text
02:18 <****> update table set field1=field1+'hola world'
02:19 <****> ok... so set field1 = concat(field1, 'hola world')
02:20 <****> are there some survey/statistics availible about mysql usage verus other databases?
02:20 <****> thnks ToeBee
02:25 <****> Ny0: http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
02:26 <****> there are several diff functions
02:39 <****> when you have an index on two integers, (field1, field2), and you perform a select.. where field1=? and field2=?, will it be as performant as a select query on only one integer field ?
02:46 <****> What can I do if I want multiple timestamp fields with default values being current_timestamp?
02:47 <****> do it in a trigger or your app. the mysql rules are too confusing
02:48 <****> FFS
02:48 <****> its hapening again now
02:48 <****> what is
02:48 <****> sql crach
02:48 <****> http://pastebin.com/m2143913f
02:48 <****> though logs ar on now normal
02:50 <****> great fss logs not on -.-
02:57 <****> Is it possible to have any sort of boolean datatype in MySQL?
02:58 <****> Octopssy: http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html
02:58 <****> there is a BOOLEAN type... but it is really just a tinyint
02:58 <****> An answer maybe possible
02:58 <****> yea
02:59 <****> Figured that, thx
02:59 <****> i think boolean is bit now
02:59 <****> what do you guys use as project management software ? I am preferably looking for something that is web based and free :)
03:00 <****> then that page needs to be updated :)
03:00 <****> url
03:00 <****> oh
03:00 <****> if that says then im wrong
03:01 <****> MtlTime: I try not to use "project management" :)
03:02 <****> I'm pretty sure there are open source solutions available though
03:18 <****> is it sometimes required/advised to have an intermediary table in a 1,N relation ?
03:19 <****> I usually create intermediary tables when in a N,N relation, but in this case, I would like to have some attributes that are only defined when a relation exists
Total 16 pages. You are browsing page 2/16.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last