| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11
Comments:
<0> isset checks if $field is set...yeh...
<0> and then proceed to the rest, else it leaves it alone
<1> okay, i'll go try some now. thanks. :)
<2> nah
<2> none work
<2> maybe you got more luck with the new mysqli functions
<3> hmm
<3> how do u list users in a mysql data base
<2> USE mysql; SELECT User FROM user;
<3> hmm
<3> im trying to use the mysql administrator
<3> but its not letting me login
<3> with the other user
<4> did you flush the priviledges table?
<5> WHERE id = X , What is the best way to make the querry when X is multiple values? it should select for example all rows where id = 1 or 2 or 4
<4> where (id = 1 or id = 2 or id = 3)
<5> k, unhandy. thnx
<4> np
<6> Does anyone have an example of using mysql in java?
<2> there's a really ugly one i wrote at hashmysql.org
<6> fantastic.. heh
<2> http://hashmysql.org/index.php?title=Java_Tutorial
<6> thank you
<1> iostream: It should be well documented on java.net
<2> there are some great tutorials if you google around
<6> Jax: I have tried google, but only found some semi-helpfull articles
<6> ^CodeX^: Could you perhaps provide a deep link? I'm still looking
<1> iostream: tried searching for mysql in the books section? sorry, I have nothing concrete, but most things should be documented there
<6> ^CodeX^: okay
<7> iostream: You should probably start with the jdbc section from the sun Java tutorial.
<6> Xgc: okay
<1> also try java.sun.com for docs
<7> iostream: Then just look on the net (or mysql.com) for the DB connection string information for MySQL, along with the MySQL specific jdbc driver.
<6> okay
<6> thanks
<7> The jdbc driver probably comes with some documentation.
<7> You're welcome.
<7> THis is probably not a bad overview of the driver and connection details: http://www.stardeveloper.com/articles/display.html?article=2003090401&page=1
<2> Xgc question, when dealing with multi language stuff. would you use the languageCode (say 'en', 'de', 'fr') directly as the reference.. or have a LanguageID for each language (numeric..)
<2> i mean the possibility of the code changing is Limes->0
<2> BUT.. who knows
<7> Jax: Either is fine.
<2> any speed differences?
<2> since it'll be using a CHAR(2) field instead of an INT(11) when searching
<7> There are going to be some obvious differences but probably not that significant.
<2> the thing is, if somebody changes the LanguageCode (which they can, since they can also add new languages).. i'd have to change it in all tables.
<2> so maybe i should go with an additional LanguageID anyway
<7> From a DB point of view, it probably makes sense to have a table containing supported languages.
<2> yeah i need that anyway
<0> i would go with the 2 letter :S
<0> so you could just have a directory called "en" "de" "nl"
<0> which it would retrieve the languagefiles from
<7> Right. But that detail is there in the language table.
<0> with numeric you get to ***ign them to acronyms like that, i believe
<2> well the languages are in the db
<0> but my knowledge on this is 0 :)
<2> because the whole frontend is generated from the database too. and all error messages, etc
<0> so treat my advice as noobnish
<2> so i don't really have language files
<0> why don't you look at how VBB fixes that? :)
<8> why is mysqld whinging that it can't open the log file?
<2> permissions?
<9> the correct response is 'because it can't open the log file'
<0> vBulletin Board puts the language data inside a table
<0> including all extra information
<9> helpful suggestions come after flippant and sarcastic response
<8> Jax: very good, this is on Mac OS X
<0> tell mysqld to NOT open the log file :P
<0> my fix :)
<2> hd420 oh yeah Mac OS X has no permissions.. *cough*
<8> DeathCore: that's the dumbest idea I've heard in quite a while
<0> hd420: but a valid one
<8> Jax: I'm fully aware of the fact that it does, but what should they be set to
<8> ?
<2> something the user you are starting mysqld as can read?
<8> chown -R mysql $DATA_DIR?
<0> is the log file even readable? :S
<0> perhaps it got too big...?
<8> DeathCore: this is the first run ever, so it better not be too big
<0> or corrupt :)
<0> happened to me a ocuple of times
<8> DeathCore: on first run?
<0> yeh, it could be
<0> or the file isn't even there
<8> Has it happened TO YOU on the first run?
<0> yeh :D
<0> believe it or not
<8> if it's not there, should the script not create it?
<0> it SHOULD, but check anyway
<2> s/touring/turing
<8> it is there
<8> and it's readable to the mysql user
<0> :P
<8> so, next asinine idea, DeathCore ?
<0> :@
<0> try doing the macintosh dance around your computer? :S
<8> DeathCore: How about you use your head to come up with some realistic suggestions?
<0> buy a new macintosh ? :S
<8> DeathCore: How about you use your head to come up with some realistic suggestions?
<0> get linux? :S
<8> DeathCore: How about you use your head to come up with some realistic suggestions?
<0> GET LINUX!
<0> it IS realistic :P
<8> DeathCore: How about you use your head to come up with some REALISTIC suggestions?
<8> no, Linux is ****e
<8> and don't try to argue this point with me, there's a whole host of reasons why this is the case
<8> besides, it's not the #linux****s channel either
<0> o.o
<0> THE PINGUIN IS CUTE!
<8> start with the network stack, Linux scraps the network stack every major kernel revision and STILL doesn't get it right, or the filesystem, mounting async is a recipe for disaster
<8> or /usr/include/linux
<8> there's a whole lot of **** in Linux not to like
<0> at least they are TRYING to get it right
<0> they don't get a big paycheck
<8> DeathCore: FreeBSD GETS it right without a paycheck, your point?
<0> FreeBSD is not linux
<8> DeathCore: hence I don't use Linux
<8> thank you for making my point
<0> >.<
<8> there's no talk of putting a webserver in the BSD kernel
<0> you can't compare linux to freebsd and vice versa
<1> please take that crap somewhere else..
<0> no :)
<8> why can't I compare Linux to FreeBSD?
<8> They're both free, both open-source, one does things in an organised manner, the other is a disaster
<1> Because this is a MySQL channel? :p compare all you want, but I don't think it's appropriate to do it here.. :p
<0> you shall stop speaking!
<8> ^CodeX^: mate, that was in response to DeathCore, not you
<8> Mac OS X is FreeBSD PPC + Aqua
<1> Allright, carry on.. :p
<10> DeathCore :P
<8> Mac OS X is FreeBSD + Aqua
<10> hd420, hahahaha
<8> Daveman: what's so funny?
<8> on a Mach microkernel
<1> What the heck was the problem with mysql on OS X anyway?
<8> ^CodeX^: I'm trying to figure that out
<8> 060129 10:03:51 mysqld started
<8> 060129 10:03:52 [Warning] Setting lower_case_table_names=2 because file system for /opt/local/var/db/mysql5/ is case insensitive
<8> 060129 10:03:52 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=Hasans-iBook-bin' to avoid this problem.
<8> 060129 10:04:02 InnoDB: Started; log sequence number 0 43655
<8> 060129 10:04:02 [ERROR] Failed to open log (file './Hasans-iBook-bin.000014', errno 2)
<8> 060129 10:04:02 [ERROR] Could not open log file
<8> 060129 10:04:02 [ERROR] Can't init tc log
<8> 060129 10:04:02 [ERROR] Aborting
<8> 060129 10:04:02 InnoDB: Starting shutdown...
<8> 060129 10:04:16 InnoDB: Shutdown completed; log sequence number 0 43655
<8> 060129 10:04:16 [Note] /opt/local/libexec/mysqld: Shutdown complete
<8> 060129 10:04:16 mysqld ended
Return to
#mysql
or
Go to some related
logs:
#redhat
gentoo fortune -m corruption
getdocumentbyid in head
bind Delegate control of a subdomain to another name server
apt tetrinet-server
#osdev
#osdev
#ubuntu
#math
extigy ubuntu drivers
|
|