#mysql
19 October 2007
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Fri Oct 19 00:00:06 2007
--- Day changed Fri Oct 19 2007
00:00 <****> doh
00:00 <****> one sec
00:00 <****> nope, wasn't it
00:00 <****> count(value list) heh
00:00 <****> can you tell me what the error message is?
00:01 <****> INSERT INTO corkboard (corkboardID, userID, name, user2ID, msg) VALUE (0, '211', 'dan', '209', 'msg goes here)
00:01 <****> that's the one I've got
00:01 <****> plus you forgot a '
00:01 <****> msg goes here ^
00:01 <****> chadmaynard: that sounds like a "yeah, technically there are, but when you need it you'll know what you need..." :)
00:01 <****> chadmaynard: crap...my paste sucked, that's all
00:02 <****> lunaphyte:pretty much
00:02 <****> fair enough.
00:02 <****> swimrr: VALUES, not VALUE
00:02 <****> thanks!
00:02 <****> swimrr: Also be sure to count your quotes.
00:03 <****> swimrr: You're welcome.
00:03 <****> THANKS
00:03 <****> but I don't think thats it
00:03 <****> let me echo the query
00:03 <****> swimrr: copy/paste the error message
00:03 <****> swimrr: I can't guess all your problems.
00:04 <****> Xgc: you can try
00:04 <****> for some reason the dan is being entered as 0 in my database
00:04 <****> swimrr: Those were two serious problems that are absolutely reasons for the insert to fail. There may be others.
00:04 <****> swimrr: Check the type.
00:04 <****> Xgc: those errors were a result of my poor paste...sorry
00:05 <****> swimrr: Then just use the pastebin and don't type manually. Copy and paste exact SQL.
00:05 <****> Xgc: crap...you know, I already checked that and didn't notice it
00:05 <****> sensei: Hi
00:05 <****> mediumint != mediumtext
00:05 <****> heh
00:05 <****> thanks guys
00:06 <****> how long is tinytext?
00:06 <****> You're welcome.
00:06 <****> lol
00:06 <****> swimrr: (-128, 128) signed
00:07 <****> so almost 300 char
00:07 <****> swimrr: no
00:07 <****> 255 integers
00:07 <****> okay
00:07 <****> 0 - 254 or -127 to 127
00:08 * chadmaynard is going to become gals next time Xgc is guys
00:08 <****> One byte normally holds 256 values. 0 - 255 or -128 to 127.
00:09 <****> yea -128 and 255 then
00:09 <****> whateva
00:10 <****> eh? he was asking about tinyTEXT...
00:10 <****> oh then i screwed up bad
00:10 <****> yay
00:10 <****> done
00:10 * chadmaynard is no good
00:10 <****> adaptr: /me agrees
00:10 <****> chadmaynard: read much? :p
00:10 <****> oops
00:10 * thumbs agrees
00:11 <****> chadmaynard: swimrr won't notice.
00:11 * chadmaynard smiles
00:11 <****> i have noticed
00:11 <****> just working on it
00:11 <****> well as long as swimrr doesn't know i'm an idiot
00:11 <****> so how big is tinytext then?
00:11 <****> swimrr: Very tiny.
00:12 * swimrr swimrr knows everyone here is smarter than him
00:12 <****> Xgc: how tiny?
00:12 <****> swimrr: The mysql docs have all this information.
00:12 <****> just thought you might know off the top of your head
00:13 <****> !man storage requirements
00:13 <****> (Column Type Storage Requirements) : http://dev.mysql.com/doc/mysql/en/storage-requirements.html
00:13 <****> swimrr: I can't see up there. For all I know, I'm bald.
00:13 <****> Xgc: we all know you're bald
00:13 <****> I can't tell with all that hair in the way.
00:14 <****> 2^8 - where is my algebra table?
00:14 <****> swimrr: 2 * 2 * 2 ...
00:14 <****> 256
00:14 <****> Even geeks can multiply by 2.
00:15 <****> heh
00:15 <****> is it possible to get mysql/php to print out the structure of a database?
00:15 <****> Yes, just dump the database without data, see mysqldump documentation
00:15 <****> hi all!
00:15 <****> hummm
00:15 <****> i have a problem:
00:15 <****> lol that doesnt sound very good lol
00:15 <****> kur1j: desc tbl_name; show create table tbl_name; mysqldump --no-data dbname tblname
00:17 <****> thanks
00:17 <****> kur1j: On the contrary, that is ideal. Use mysqldump with --no-data
00:18 <****> Xgc: i just have MySQL do my math
00:18 <****> humm what if i dont have shell access?
00:18 <****> Then you can't do anything
00:18 <****> phpmyadmin?
00:18 <****> You can run mysqldump from a non-local host
00:19 <****> You can run mysqldump from anywhere provided you have access and permissions
00:19 <****> humm i thought it was a linux/unix utility :-/
00:19 <****> If you don't, then your hosting provider provides nothing useful, shun them in favour of a decent one.
00:19 <****> No, it will work in any OS that mysql support it on
00:20 <****> i run mysql using inoodb(database size is 6.5G, one file). the machine is a sempron 2300+ freebsd-stable 32bits with 512M RAM. Other server is a dual xeon with 1024M RAM and freebsd-stable 64bits, database inoodb(using files with 4GB). The same query is executed in <300ms in the sempron and in dual xeon its over 6000ms. Any idea of the problem?!
00:21 <****> No, we cam
00:21 <****> can't tell from that much information. are the schemas identical? I assume these are non-production boxes that you can do what you like to- can you change settings without affecting any production?
00:22 <****> Are the my.cnf identical?
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last