| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
Comments:
<0> If Only I Actually Knew What MySQL Did Cause Ive Only Used PHPMy Admin To Make Databases and Crap Like that
<1> smotts2002: buy a donut and don't think about it
<2> i have a databse in .sql format and i want to know if tis possible and how i cant import her in mysql 4.1 ??
<0> See Im So Retarded I Dint Even Understand That Which Probably Was An Insult
<3> I love the first word caps...
<1> smotts2002: ehr .. I'm not insulting you
<0> sry
<0> its a bad typing habbit
<0> meh
<3> I was serious.
<0> sry
<1> c0uin: try and you will know it (her?)
<0> I have a bad typing habbit
<4> todointx: heh this fix .. is more than a "fix" ... i actually need to do work that'll pay me. if you have time i would say you do it. or i'll try to do it sometime in the next two days :)
<5> alphablue: na, I got it covered.
<4> i don't know my bash very well, and i don't wanna use it as a command line option to ahve the p***word displayed
<6> actually
<5> ah... yea
<6> MySQL hides the p***word in 'ps' output now
<6> if that's what we're talking about
<0> MUHAHAH IVE GOT APACHE TO WORK I FEEL SMARTERER
<4> all versions ?
<3> alphablue, tias :) Should be any version you should be using now.
<4> will: it's just for the script todo wrote, he may run into people using 3.x
<4> i don't have 3.x
<3> ****s to be a 3.x user...
<7> /administrator
<4> \/peon
<5> alphablue: ok so perhaps write/append a ~/.my.cnf from script input then have mysql read it from the user's cnf ?
<4> what if someone has their own stuff in there ?
<5> if the ~/.my.cnf doesn't exist then write to it.
<5> if it does make them set the user/p***word in it.
<5> 99% of the time the .my.cnf does exist it is for holding p***word
<8> !m infi benchmarks
<9> infi: (Using Your Own Benchmarks) : http://dev.mysql.com/doc/mysql/en/Custom_Benchmarks.html
<4> at work we have users who have the my.cnf set with a different p***word .. of course normal developers won't be running it
<4> but..
<4> dev's don't have root access to the db etc
<5> you reall don't need 'root' level to run this script I don't think.
<5> reading global and status variables is given to all users.
<5> even anonymous
<4> i think i got it
<10> Where is htdocs located?
<5> redblade: whereever your apache' DocumentRoot points to
<4> todo: i got it to read the p***word from input
<5> but the script does alot of mysql -e ... stuff
<5> are you p***ing $user $p***word when mysql is called ?
<5> if so then the p***word may be exposed.
<11> !perror 150
<9> MySQL error: 150 = Foreign key constraint is incorrectly formed
<4> todointx: Darien said new versions of mysql hide that in ps
<5> right.
<6> yeah
<4> but for the 3.x people..
<6> the 3.x people need to upgrade ffs :/
<5> but is there still that split second where it can be exposed in ps?
<5> Darien: I don't have that luxury
<6> oh well
<4> and, actually my read is in the clear as well
<5> I have easily 6000-7000 servers that are RHEL 3 or lower.
<5> almost all with 3.23.x
<6> dan 23642 0.0 0.1 28824 900 p1 S+ 2:40AM 0:00.02 mysql -px
<6> TodoInTX: ****s to be you bro
<5> no, not really I just have to be flexible
<6> dude, you have RHEL servers
<6> that's like the worst punishment I can think of
<6> I'd rather admin NT4 than RHEL3
<5> I don't have much say on that.
<5> BS
<6> it's too bad RedHat is such a piece of **** :/
<6> I used to make fun of Gentoo being worthless, but I don't anymore, since using RHEL3
<5> RHEL3 is way the hell better than NT4 c-mon.
<6> dude
<6> what I can do in Debian in three hours has taken me two weeks to do in RHEL3
<6> because half the packages I need and their dependancies aren't in up2date
<5> a good tech doesn't blame tools. ;)
<6> and also because up2date has no apparent search function
<6> RHEL3 isn't a tool, it's a piece of ****
<6> if I'm going to build a bridge I need more than an awl
<4> but i like rhel 3 and 4
<5> up2date --showall | grep <pattern>
<6> uh
<4> probably cuz i know it better than debian
<6> that's not searc
<6> h
<6> that's an ugly hack
<4> or up2date --whatprovides
<6> RHEL is the ugliest distro I've ever used
<6> it makes me miss Slackware 3.2
<5> I agree I much prefer RUG but it's what I have to work with.
<4> rug ?
<5> red-carpet
<4> oh so novell ?
<12> hi there... I need to make a db with about 80 000 Datasets in it.. , And query it sometimes lets say with more or less complex stuff.. what do you think would that be to much for mysql ?
<4> i've used mdk, rh, suse, gentoo and debian. i think i'd go with rhel, suse, gentoo, debian and then mdk
<12> Is it better to use Oracle in that case, or will it still work fast on Mysql ?
<4> a database with 80,000 tables ?
<12> 80,000 Adress entries
<12> not tables :-)
<4> oh
<4> mysql will be fine
<12> its one table with 80,000 Entries
<4> 80k is not much
<5> no big deal
<4> but if you have the money for oracle.. i can lend you my expertise in mysql..
<12> :-)
<12> hmm nope dont have the money for oracle.. but they have their 10g XE for free now
<4> todointx: so are you re-writing this with expect or something for the -e ?
<5> -e ?
<5> I was thinking it should be reincarnated into PERL
<4> mysql -e
<3> alphablue, I seriously can't wait to get my dual monitor setup.... ARG!
<5> it was a quick hack that got away from me.
<4> heh, my quick hack at: http://www.phpcult.com/tuning-primer.sh
<4> will: hehe when does the dell arrive ?
<4> todointx: look at line 730-741
<3> alphablue, Between Wed and Friday.
<4> cool
<3> I go to AZ on Friday! :( I can't play :(
<2> its possible to modify the order of champ in the table ??
<4> btw, that 24 inch is now on sale for $799.20
<4> couin: ORDER BY
<13> can somebody help me.. i am having problems to start mysqld on freebsd
<3> I get Dish Network on Wed. Yeah, my friend told me about it. For $800, I rather have two 20"
<13> my error log is here: http://hashmysql.org/1544
<4> yea, the 20 is going for $458
<3> Little less...
<3> $436 or something
<4> :)
<3> :)
<4> i need a new laptop or a new video card for my desktop to be able to do dual desktops.. so i'm just gonna wait
<4> exorciser: the error log says the user mysql doesn't have permissions in the datadir
<4> specifically /var/mysql
<13> alphablue: how do i chown /var/mysql for mysql user ? pls help
<4> chown mysql:mysql /var/mysql
<4> ?
<4> i dunno what group the user mysql belongs to on freebsd
<5> alphablue: $1 is used by the case to limit the output
<4> todointx: see line 724-728 i made that $2 :)
<4> so tuning-script p***word all
<4> hmm won't work if i did tuning-script all ..
<4> bah
<13> alphablue: i chowned /var/db/mysql, but now error log says.. 060307 9:00:42 [ERROR] /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
<5> alphablue: I can just redo it all in perl and then deal use DBI to connect.
<4> did you run the install_db scripts ?
<5> that way I can more easily connect to external hosts too.
<13> alphablue: i did. but still doesnt start
<5> exorciser: why aren't you using /var/db/mysql ?
<5> did you install mysql from ports ?
<2> alphablue: i have two dbs and i want to do only one with the twice. Its possible ??
Return to
#mysql
or
Go to some related
logs:
#gaim
yum + No Match for argument: dhcpd
ebuild e_modules
python bncs
XEN UBUNTU 64
ubuntu and suepruser
kaffeine kubuntu xvid
debian sdl fullscreen
dofade con javascript
R200Setup X version mismatch gentoo
|
|