| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> inviso, I've go MYD/MYI/frm's from 5.1.9 and I want to dump them so i can reload into 5.0.20 but i don't wanna run mysql 5.1.9 while it's dumping :)
<1> xlx, you mean like if the server wasn't running?
<2> inviso, im p***ing the queries thru php thats what me and my friend are working on
<0> jy, ya
<2> so php says 1-18
<3> xlx: You'll need to bring up 5.1
<2> should have told that sooner.. apologies..
<0> inviso, tight :) k thx
<3> Rarj: I don't care what PHP says. What does the database server give as a result?
<4> PHP ****s
<2> all it shows is 1-18
<3> bull.
<0> i just started up 5.0.* and get sigfault's 11 so I gotta reimport hehe
<2> :(
<0> could be the triggers, not sure what's up but just gonna start fresh
<3> connect to the server with the mysql command line client
<3> Rarj: Anyway, it will show you that autocommit is set which means rollback wouldn't have an effect anyway. You're totally and completely out of luck :)
<2> what abt log files ?
<3> If you had the log files for the inserts and updates for all of time or since some backup in the past, you could replay the log files up to the point where you starting fouling things up.
<2> inviso, what abt log files ?
<3> Having the log file for the delete/update that borked stuff will do you no good though
<2> so theres no way
<3> Not without backups or full log files
<5> how I join two strings? str1 + str2 ?
<6> concat
<3> !m backz CONCAT
<7> backz: (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<2> i see some logs files abt 40 mb in size
<5> um. ok, I'm trying CONCAT()
<5> CONCACT
<5> ok
<8> how do you start mysql under linux with "--skip-grant-tables --user=root"?
<3> !m Rarj mysqlbinlog
<7> Rarj: (The mysqlbinlog Binary Log Utility) : http://dev.mysql.com/doc/mysql/en/mysqlbinlog.html
<3> !m fiber0pti reset root
<7> fiber0pti: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<8> I'm already looking at that which is why I'm asking how to actually start it with those parameters.. that url doesn't explain
<8> it just says start mysql with
<8> "--skip-grant-tables --user=root" but not how to actually p*** those parameters on start up
<9> mysql --skipt-grant-tables --user=root
<10> why is mysql giving me this?: 0xbf6fbce4
<3> fiber0pti: it explains, step by step, the exact commands you need to run. That's why I linked it
<3> Fushuing: sun spots
<9> why inviso ?
<8> I get the error: mysql: unrecognized option `--skip-grant-tables'
<10> inviso: uh?
<3> Fushuing: exactly
<11> Hey guys
<3> fiber0pti: of course you do, mysql is the command line *client, not the server. Follow the instructions
<10> what would the possibility be that it is giving me this value? :|
<3> Fushuing: The sun spots? About a 54% chance, I'd guess
<10> and what would the cause be?
<8> I don't understand. how do you get into the mysql client?
<3> Fushuing: We have no idea what the problem is. You've given us exactly zero context.
<10> because there is nothing to it :|
<10> a C++ application requests a row and displays it, done
<10> nothing else is being performed
<10> and it only does it to some rows :|
<2> sql, can i get some data back from ib_logfile0 and 1 ?
<10> but i think i have found the error -_-
<10> on C++'s side
<3> Fushuing: What are you expecting? What query are you running? What does your table structure look like? What type is the column? What api are you using to connect? What character set are you using? What does that data look like in the command line client? etc, etc, etc
<9> fiber0pti mysqld = daemon that runs the datebase mysql= client you use
<9> Inviso What is wrong with my Nick ?
<4> --i-am-a-dummy
<6> does it mean "booboo"?
<12> Bye, and thanks again! :-)
<9> Yeah gleam_
<9> but BooBoo is normally in use
<4> I made a booboo in the toilet.
<9> it's a RL nickname that i never wnated but have grown to accept
<9> From the old Cartoon of Yogi and BooBoo
<9> it **** when you are glad to get back to work after a holiday
<9> +s
<13> "But Yogi! Mr. Ranger is not gonna' like this!"
<9> Well F*ck the ranger Yogi
<13> "Neeeyah, Booboo! What Mr. Ranger doesn't know won't hoit him!"
<14> SELECT VKDatum FROM Transaktionsdetails ORDER BY VKDatum LIMIT 1
<14> it says there is a missing operator
<15> where?
<14> 'VKDatum LIMIT 1'
<15> give me the whole error
<14> you got it
<14> it is an access error
<14> translated in english
<15> the entire errors as mysql sent it to you
<14> Syntaxfehler (fehlender Operator) in Abfrageausdruck 'VKDatum LIMIT 1'.
<15> yeah I have no idea
<15> I can't read that, sorry :(
<14> 23:31:56 [ Kalleos ] it says there is a missing operator in 'VKDatum LIMIT 1'
<14> ah
<14> shouldn't there be asc or desc?
<16> not needed...
<16> it sounds like you are using an old version that does not support LIMIT at all.
<14> this could be realistic
<17> hey
<17> how do I make it so my SELECT * FROM tbl WHERE (foo = bar) , how do I make it so that foo=bar isnt checked case sensitive?
<15> are the columns binary?
<1> put them both to uppers or lowers?
<17> well what im doing is a registration system
<6> by default they aren't compared case sensitive
<17> so it checks if the username exists.. and if endra exists, Endra doesn't show as existant
<3> endra: By default, comparisons are case-insensitive. If you're using a binary charset (as firewire eluded), you get case sensitive comparisons
<3> gah
<17> im not sure if im using binary charset.. im
<3> alluded
<14> well i use now SELECT max(VKDatum) FROM Transaktionsdetails
<14> but
<14> it returns me a date which i nowhere can find
<6> how windowsy
<14> ...
<17> nvm
<17> im stoopid
<17> thx
<3> ...
<17> ill idle
<17> lol
<3> Glad we could help you figure that out ;)
<17> :) thx
<3> Kalleos: select * from Transaktionsdetails where VKDatum = 'the_date_from_max_vkdatum'
<18> I want to create a column in my table but the value will always be either 0 or 1, what type do I use? Binary ?
<17> Bool
<18> endra: Which means?
<17> Boolean?
<17> or tinyint(1).. whichever turns you on
<17> a boolean is just true/false or 0/1
<18> isn't that true/false ?
<14> infi
<14> inviso you meant SELECT VKDatum FROM Transaktionsdetails WHERE VKDatum = max(VKDatum)
<14> ?
<18> will tinyint(1) save as much space ?
<14> i got the error: aggregatfunction in where (VKDatum=max(VKDatum) not possible
<14> aggregate*
<17> Aleo I dont know.. :-/
<6> tinyint(1) won't save you any space over tinyint(3) or tinyint(4) or tinyint(1000)
<6> it will save you 3 bytes over int.
<14> does max with date types really work?
<15> yes
<6> is your column type really date? not, say, varchar with your dates formatted like mm-dd-yyyy or something?
<14> yeah
<14> it got a format like
<14> well the type is date!
<6> just making sure :)
<6> then yes, max(datecol) should work fine
<3> Kalleos: show create table tablename; Put that output in the pastebin
Return to
#mysql
or
Go to some related
logs:
#linuxhelp
libssl.so destest error while loading shared libraries
#math
#python
xorg debian mga_hal
#debian
#perl
#ubuntu
sane cannoscan lide 35
boinc chost unknown
|
|