| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
Comments:
<0> not sure really.. I usually just use Phpmyadmin to export import
<1> No web here
<2> sql in normally shorter
<0> you can upload phpmyadmin to your server ..
<1> No web
<0> but if you wanna do an actual query search google
<0> ffs why doesn't this work UPDATE cdl SET image = REPLACE ( image, '%,', '' );
<0> 0 rows affected
<1> akumanz: Use double-quotes
<1> interpolation vs. interpretation
<3> setuid: that doesn't exist in mysql
<1> Line 58 is 1.7M
<1> Why does it think that exceeds max_packet_size?
<4> setuid, are you using phpmyadmin?
<1> pwnt: No
<1> max_allowed_packet = 256M
<4> use phpmyadmin, and zip the file
<4> gz
<1> # mysql mantis < /tmp/mantis.sql
<1> ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes
<1> pwnt: NO WEB... I don't have a webserver to run phpmyadmin on
<0> nah man. 0 rows affected - UPDATE cdl SET image = REPLACE (image, "%," , "");
<1> This is just mysql
<4> FINE!
<0> its mysql 4.0.. does that not support wildcard or some crap
<5> akumanz: You're misunderstanding something.
<0> XGCCCCCCCCC
<4> akumanz, you dont need to say insert into every time
<4> just one time
<0> whats crackilating man
<6> Hey all, I just have a (hopefully) quick question: Can I easily upgrade from 3.23.58 to 5.0.18?
<5> akumanz: There's no wildcard in reaplce().
<5> replace
<0> ah crap i knew it
<1> Haoshiro: no
<0> so what do i do :/
<7> i've just installed mysql (on gento) for the first time. i'm having some problems iwth root's p***. here's the error : Access denied for user 'root'@'localhost' (using p***word: YES
<5> akumanz: Try a regex.
<6> setuid: well that ****s :(
<4> akumanz i told you that like 200 lines ago.
<1> This syntax is wrong: http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
<1> sigh
<4> and the solution
<1> someone needs to *TEST* the things they write
<0> geez.. man i aint this advanced.... What should i google for
<4> aku, i gave you the solution
<4> if i was stormchaser, i would ban your ight now out of spite
<4> and then ban the whole channel
<1> wow
<0> <3
<1> both of those are wrong
<0> yeah you gave me half a solution though.. i tried googling for the other half but failed
<6> setuid: could you give me any other info? i've googled with no luck
<4> no, whole solution
<4> update table set field substr(strpos(
<0> nah man you gave me what was it hmm
<4> i dont know the mysql syntax for those two funcitons, but thats the answer
<7> does anyone have a working gentoo/mysql guide they would kindly point me to ? I'm using the gentoo.org guide , and i'm failing at listing 1.4... while trying to setup root's p***. thanks :)
<0> yeah
<4> find the pos, then substring from that pos
<0> for shizzle.
<1> wow, 5.1 is a mess
<0> good times
<1> Watch this:
<4> 5.1?
<1> mysqld_safe --help | grep defaults-file
<1> --defaults-file=FILE Use the specified defaults file
<1> # mysqld_safe --skip-networking --defaults-file=/etc/mysql/my.cnf
<1> Starting mysqld daemon with databases from /usr/local/mysql-5.1.6/var
<1> STOPPING server from pid file /usr/local/mysql-5.1.6/var/angst.pid
<1> 060220 18:02:31 mysqld ended
<1> And the .err says:
<4> omg flood
<1> 060220 18:02:31 [ERROR] /usr/local/mysql-5.1.6/libexec/mysqld: unknown variable 'defaults-file=/etc/mysql/my.cnf'
<0> attackkkkkkk
<1> Love it... its incompatible with itself.
<1> And the syntax on the dev.mysql.com page is completely wrong
<4> i cant stand the flooding
<0> hate it or love it the flooders on top. he gon flood homy until the OPs block
<7> ok, mayber someoen can point me to a guide to flush all the mysql settings, and starting over then ?
<0> go head envy him. hes #mysqls MVF and he ain't going nowhere so you betta get to know him
<8> So...
<0> ohgood - /quit
<4> oh ****
<0> anyone here use FTP via dos?
<4> i did
<7> akumanz: i think that will solve very few of the current things i'm experiencing.
<4> its handy
<0> dam that's crazy
<0> commands like "bye"
<4> pwnt
<0> intense
<4> yet if you rtfm, you'll see that a lot of it is ftp code
<0> closest i've ever gotten to hacking or looking like i'm hacking from someone elses view
<0> dos ftp
<4> i prefer showing a n00b how to edit his website in dreamweaver and switching to code view to find a problem
<7> Can anyone tell me why i get Access denied for user 'root'@'localhost' (using p***word: YES) while trying to setup root's p*** ?
<4> they're always like omg matrix
<0> nah man Dos fTp black & white
<0> thats how i roll
<4> you're using hte wrong p***word
<5> akumanz: UPDATE cdl SET image = SUBSTRING_INDEX(image, ',', -1);
<4> dos is black and white?
<0> xgc: sweet
<7> pwnt: i've yet to set a p***word
<4> but you're using a p***word
<4> (using p***word: YES
<7> :|
<0> what the
<4> yay i answered a question
<4> afk
<0> omg it worked..
<5> akumanz: Test it. That will find the last ',' and return the following substring.
<0> yeah it worked. it removed all the data before the ,
<5> akumanz: You're welcome.
<4> nice xgc
<0> and the , itself. sweet
<1> How do you set variables runtime?
<0> so if i set -1 to 0
<0> will it leave the , in?
<5> akumanz: No. Your SQL didn't want that.
<4> the world may never know
<0> ah ok. and how do you do it the opposite way? ie remove data AFTEr comma
<5> akumanz: 0 would not be valid.
<5> akumanz: -1 means search for the ',' starting from the end of the string.
<5> akumanz: 1 searches from the start of the string.
<4> pretty pwnt
<0> ah ok so 1 to delete after -1 for before
<0> sweet.
<0> what string do you use to add text to end of a column? concat?
<1> | max_allowed_packet | 1048576
<1> hrm
<5> akumanz: +# searches from start, -# searches from end.
<0> yeah sweet. now i just needa add .jpeg to the end of every image data column
<5> akumanz: # determines how many tokens to find. 1 means find first. 2 means find 2nd. etc.
<0> <3
<0> yo so whats the function for adding string? would this work set image = (image, '.jpg');
<1> hrm, this is weird. Where does mysql pick up its my.cnf from by default on a source install?
<1> What a mess
<5> akumanz: CONCAT()
<0> yeah hold on running it now
<0> yeah sweet UPDATE cdl SET image = concat(image, '.jpg');
<4> yea, mysql ****s. lets all use oracle
<0> gg owned. mission accomplished
<4> you got it aku
<0> time taken to complete level. 1 hour 46 minutes
<4> items found: none
<0> special areas: none
<0> bonus: none
<0> bans: 1
<5> Chicks dated: none
Return to
#mysql
or
Go to some related
logs:
#css
update-desktop-files ubuntu
#ubuntu
#lisp
kubuntu kdevelop find x includes
arptype 0 not supported by libpcap
Gentoo error: 'CLK_TCK' undeclared
vlc Error of failed request: BadWindow (invalid Window parameter)
suse sld 10 repository
how to enable framebuffering
|
|