| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
Comments:
<0> u can use them where mysql new db files
<0> no way you can open mysql from a shell or mysqladmin, to make a backup?
<0> as .txt or .sql?
<1> nope :/
<1> I cannot start mysql
<1> it needs to write files at startup
<0> unless someone has a better idea you need to copy your db files from the mysql directory
<1> ok, I think I will just try it out :)
<0> :)
<2> MySQL 5.0.18 is GA <-- what does 'ga' mean?
<1> they missed the "YW
<3> general availability
<1> -W
<1> :)
<4> grape ape
<5> lokus, same error
<2> lsmith: thanks
<5> lokus, suggestions?
<6> no idea, have not use slackware or the package tool
<5> what is the command to chown chgrp a dir and everything under it.. chown -R 666 /var/lib/mysql ?
<5> that owuld put everything under it owned by mysql and make it 666?
<6> Invisible_Slack: try chown and chgrp first no need 666
<5> chown mysql -R /var/lib/mysql didn't make the test folder in there owned by mysql
<7> Xgc, are you there?
<6> chown -R mysql /var/lib/mysql
<8> good morning!!
<8> anyone successfully get Access 2003 to link tables to mysql 5?
<8> or how about some tool that will enable me to (gasp) export the CSVs of a mysql5 db and properly import to access without type mismatch gagging? :)
<5> Think that did it.. brb
<5> lokus, well that worked lol
<9> hellow. how do i changefrom utf8 to latin1 in mysql
<9> (for default table language)
<10> Cardiba: http://dev.mysql.com/doc/refman/5.0/en/charset-convert.html
<9> Kemurii: thanks. :)
<10> Cardiba: and changing an existing tables default charset is using ALTER TABLE
<9> heh ok :)
<11> hi
<12> hi guys, I'm trying to create a stored procedure and did it like this:
<12> Delimiter $
<13> wait
<13> wait stop
<13> stop
<12> ok
<13> ok
<12> its only a small one :|
<13> how long is it?
<12> 4 lines?
<13> because if it's more than a line or two, a pastebin is a lot easier to read
<13> ok, yeah, pastebin
<12> ok
<13> see the topic
<13> no one would have yelled at you or anything, but it would be easier to read, is all :)
<12> ok
<12> so I tried making a stored procedure like this:
<12> http://pastebin.com/584987
<3> domas: did you see quoteInto() in ZF?
<3> who stupid is that?
<12> however It wouldn't have any of it, the query works, so any idea where I'm going wrong?
<13> MikeH: do you get an error?
<3> ah yes you did
<3> looking at your blog post
<12> Darien: my error: http://pastebin.com/584991
<13> MikeH: what version of MySQL?
<13> 4.x ?
<12> oh
<12> I just thought
<13> the good news is, your stored procedure is written properly ;)
<12> yeah its 4.x, I was thinking it was my other server on 5.x
<13> my server likes it
<12> 4.x doesn't support stored procedures does it?
<6> MikeH: anyway, you should improve the select
<13> MikeH: nope
<12> lokus: why? it works, and does what I want it to do.
<14> lsmith: yes
<3> i think you are way to friendly still about that method
<6> the subquery could be executed many times, once for every row in users
<3> did you look at the implementation?
<14> lsmith: nope
<14> not yet
<3> str_replace()
<3> thats all
<14> =)
<14> can't be
<14> are you sure?
<3> yes .. it does not use the prepared API the way it looks to me
<3> but maybe i overlooked something
<15> ZF is the so ****ty it's not funny.
<13> ZF?
<13> ZIF?
<15> Zend Framework
<13> ooh
<13> porque?
<15> I guess it can't be helped cause PHP is ****ty.
<13> an excellent argument
<13> how one would rebut that, I do not know
<13> mr poopy-head
<13> >:|
<15> lol
<3> public function quoteInto($text, $value)
<3> {
<3> return str_replace('?', $this->quote($value), $text);
<3> }
<15> PHP is what you get when you cross C with Java.
<13> yes, it is
<13> and perl
<13> to a very small extent
<13> PHP's OO (especially in PHP5) is Java without the Java
<15> Basically.
<13> other than that, it's very C-like, except that it's far more readable
<13> actually
<14> lsmith: :-D
<15> Far more readable, I don't know. The C-derived function names are understandable, but damn the others.
<13> considering that most PHP functions are wrappers for identically-named C functions, I don't know what makes it more readable
<13> people writing C seem to lean towards being terse with variable/function names
<15> Darien: IMO it would have been better if it *didn't* try to be like C.
<3> domas: and the DataObject stuff is only in the docs
<3> its not in the code
<13> kuja: I disagree
<13> kuja: it's not like it's trying to be C for the web, its just using similar syntax, which many languages do
<14> bah
<15> Darien: That's true, but you get people who don't know C, and then try to write PHP.
<3> and appearently their oracle guy doesnt know about delimited identifiers in oracle
<13> kuja: just because they don't know C doesn't mean they're going to be bad at PHP
<13> kuja: it just means that they have to learn everything from scratch
<15> Right, and they really **** themselves over in the process.
<13> not necessarily
<13> I learned PHP before I learned C
<13> and I'm not some uberhacker, but I'm no slouch
<15> I hate to admit it, but me too. I learned for 3 years. I spent probably a few months learning PHP, and the rest of my years learning how to not **** up with PHP.
<13> hehe
<13> the scary thing is, I was looking at some of my old code from 2001
<13> that I wrote back when I was learning MySQL and still kind of newbish with PHP
<15> I think PHP might have had more success if it tried to mimic Java without the restricted datatypes.
<13> and it was really solid code
<13> kuja: how much more success could it get?
<13> it's available on pretty much every webhost out there
<15> The OO model is more popular, and sure succeeds well in the web.
<3> reminds of me all the people mocking PEAR ..
<15> Take for example, and elegant OO model like Python or Ruby.
<15> s/and/an/
<3> we are getting over half a million downloads per month
<3> i am not worried about our success
<15> lsmith: PEAR has its ups and downs.
<3> s/elegant/academic
<3> kuja: certainly
<13> kuja: the only benefit Ruby provides is through Rails, and that benefit is the MVC paradigm brought to the web
<13> which should have happened a long time ago, imo
<15> Yes, MVC is like 20 years old, or less.
<3> rails is just a good combination of things long available in php ..
<3> but its very well integrated
<15> lsmith: Incorrect.
Return to
#mysql
or
Go to some related
logs:
#perl
ubuntu w3m-img
#mysql
grub hard disk error raid1
#linux
utf8_general utf8_unicode
#debian
ftp.perl.org error in server response
preg_match shortest occurrence
unfck_gpc()
|
|