| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> But to want to "prove someone wrong" is just immature.
<1> I use "select * from table". How can I tell mysql I want a timestamp for my "bk_date" column instead of the datetime format?
<2> will[werk]: Not when they obviously don't know what they're talking about. :P
<3> any perl DBI users here? what happens if a row is added in between calls to $sth->fetchrow_* that would have been included in the original query?
<2> bluetree: Um... there's a function called DATE_FORMAT. Maybe that's what you're looking for?
<0> bluetree, You should not use * in that case.
<4> someone know how to retrieve data from binary files of mysql ? the only backup i have from my base is /var/lib/mysql ! ... any way to retrieve them ??
<0> CapNemo, Load them up in a MySQL server.
<1> will[werk]: how would I go about modifing it but getting all the date at once?
<4> will[werk], what do you mean by loading them ?
<0> !m bluetree date and time function
<5> bluetree: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<0> CapNemo, Install MySQL. Put files in datadir, Start MySQL. Use mysqldump.
<0> How do you want to retrieve the data? What format do you want it as?
<4> will[werk], do i put all of them of just those contained in a directory ?
<0> Elazar, Basically, I'm saying you shouldn't be a jerk about it when you didn't know the answer to begin with.
<0> CapNemo, Wouldn't hurt to put all of them in...
<4> will[werk], ok i should try it
<0> OK!
<4> thanks
<2> will[werk]: Fair enough.
<6> hi ive installed an MSDE SQL instance successfully, however i cannot get it to appear under the "SQL Server Service Manager" with the rest of the instances. Any Ideas?????
<0> We really do not deal with Microsoft products here...
<0> Just letting you know :)
<7> the cure is format c:
<6> can u reccomend any places where i can get instant help?
<8> and instant help center maybe?
<2> weeeeheee: Microsoft = capitalistic corporation. You get what you pay for in the world of capitalism. :)
<7> less than free
<0> Elazar, I'm not into bashing other products either.
<2> will[werk]: *shrug* Just pointing out a fact.
<2> will[werk]: Not saying the product is any better or worse than anything else.
<0> Microsoft has a lot of support options.
<0> products/companies :)
<2> will[werk]: As far as I can tell, there's no channel for MS SQL on FreeNode. ;)
<0> Freenode is specifically for opensource projects.
<9> not freewarez
<2> will[werk]: It's not, though I think more channels than not are used for that purpose.
<9> so, uhhh i need to do a background check on someone..
<0> Freenode provides discussion facilities for the Free and Open Source Software communities, for not-for-profit organizations and for related communities and organizations.
<0> Elazar, freenode.net
<9> http://www.
<2> will[werk]: Ah, sorry, misread what you said. :P
<10> hey there. can someone help me with this error? Warning: mysql_pconnect() [function.mysql-pconnect]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (13) in /srv/jura_neu/t3lib/cl***.t3lib_db.php on line 831
<11> Morimando, #php issue
<11> Morimando, or just change localhost with 127.0.0.1
<10> in mysql or in typo?
<0> Morimando, Don't use pconnect to start.
<12> back
<12> account int UNIQUE AUTO_INCREMENT varchar(10) not null default '2006-00001'
<12> does this look right
<12> I got the other code to work
<10> damnit it works since i replace localhost with 127.0.0.1
<10> darn thing
<13> no
<12> ok
<13> you can't have an auto_increment varchar.
<0> heh
<12> ok
<12> not my code a broken module I was handed to fix
<13> oh, wait
<12> they want it to use the year -number for new account numbers
<13> I think you're just missing a comma
<12> ?
<13> you have two column definitions there
<13> but no comma
<12> explain
<13> you have two column definitions there
<13> and you don't have a comma between them
<12> its 1 colom
<13> no, it's not
<12> ok I am still learning and I have the mysql book and it did not have the answer
<13> also, you need a column name for the second one
<14> Tier_1: "int" and "varchar" are conflicting.
<14> Tier_1: either you have defined two types for one field, or you are missing a name and a comma for the secodn of two fields.
<13> actually, what in the hell is ist supposed to be
<12> ok how do I defint the firstpart to use a year-#
<13> it looks like a two part key
<12> its for new accounts
<14> Tier_1: "first part"?
<13> you can't do exactly what you want
<14> Tier_1: one column has one dataype.
<12> they want the account number to start with 2006-# and auto incrament
<14> what you want seems to be two fields
<14> which are treated as one id
<14> i.e. you have a composite primary key
<14> using two fields.
<14> Tier_1: the way to do it is to have two separate fields in the database.
<12> man this is confusing but am trying
<13> year_created smallint, year_id int auto_incremement, unique key(year_created, year_id)
<12> ok
<13> something like that.
<14> you can even create a view that makes a single "virtual" field out of those two :)
<12> yeah somewhat
<15> hi - I have a serious problem - for some reason last night, a file called ISAM reached 100GB! basically locking the whole server. Can someone tell me how to remedy this? I'm having trouble accessing the DB to se whats going... is there a safe mode?
<13> you need to increase the size of your data partition
<7> Baz join mysql network
<13> oh, and upgrade from ISAM tables to MyISAM
<12> yearid would be just a number
<13> and from <3.23 -> something reasonable
<12> ok hmmm
<7> Im surprised ISAM could get to that size
<14> Tier_1: the second field would just be a number too, right? Anyway... do you want the counter to start with 1 for every new year? that's not possible with auto_increment.
<12> yes
<13> it is
<12> thats what they want
<13> if it's a secondary part of a unique key
<15> yesterday my entire DB was 200MB, today its 100GB? Is there anyway to find out whats taking up all the space?
<0> It got smaller?
<14> shannon: really? it's reset to 1 if the first part of the key changes? Uh... that means mysql has to maintain an autoincrement counter for every possible value of the first part of the key?!...
<14> will[werk]: MB, GB...
<16> I suspect it's jut read each time from the index
<12> ok then this line would be correct
<12> account year_created smallint, year_id int auto_incremement, unique key(year_created, year_id)
<14> yep.
<12> with out the year created
<16> account_year_created
<14> no.
<7> Baz sounds like serious corruption of some sort
<16> increment
<15> archivist - those are not the words i wanted to hear
<12> ok so change year created to the year'
<12> or will it get the year
<16> baz - check the data dir to figure out what tables / logs it is
<7> the size seems well out of range for ISAM type
<16> then you'll have an idea what's going on.
<12> account smallint, year_id int auto_incremement, unique key(year_created, year_id)
<12> tahst the line I have
<12> that should work\
<12> ?
<15> i logged into administrator and highlighted each catalog and looked at the "Dta Length" property at the bottom and everything seems to be fine
<15> i also went to the dir were the data is stored - each DB has its own dir - but the problematic ISAM file is outside of them
<16> outside?
<12> hmm ok
<16> maybe some other sysadmin copied a file there or something?
<16> is it ISAM or like ibdata
<17> I hope to god you mean MyISAM
<7> Baz version of mysql?
<12> ok off to test
<18> Hey
<18> I get an error sayign 'There is an error in your syntax' with this query: UPDATE tcm_mod_menu SET name = 'Menu Management', permission = '1', order = '1', url = '' WHERE id = '4'
<15> i am the only sysadmin - unless i got hacked... the exact path of the file is: C:\Data\MySQL\DataFiles\isam (thats a filename without an extension) and my chemas are in subdirectories, i.e. C:\Data\MySQL\DataFilee\DB1\*.frm, C:\Data\MySQL\DataFilee\DB2\*.frm
<15> i am on version 5
<16> !m AlexC_ reserved words
<5> AlexC_: (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<7> AlexC order is a reserved word
<15> 5.0.15 to be exact
<18> archivist, sjrussel Ahhh yes of course
<18> thank you both :)
<15> my ibdata1 file is 174mb
Return to
#mysql
or
Go to some related
logs:
gdesklets starterbar fc5
MySQL JDBC Unexpected end of input stream MysqlIO.readPacket
ferronica
#linux
ubuntu theme preferences stuck
ubuntu dapper apt-get install openoffice
kubuntu hyperterminal
ubuntu instll ndiswrapper
cxacru.deb
gentoo openoffice-bin download
|
|