| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
Comments:
<0> "/usr/bin" ... yes
<1> I am using SSL + p***phrase , when i start mysql its only wait for very little while , not enough to type p***phrase
<1> and then fails
<2> and /etc/init.d/ has a mysql or mysqld in it?
<0> good ?
<0> lets jsut see
<3> is the "mysql"-command able to connect to servers other than localhost? I cannot find anything about this on the man-page.
<2> BooBoo[home]: also, find mysqld. Probably in /usr/sbin
<1> 2nd time when I start mysql it doesnt ask for p***phrase
<4> roland: mysql -h
<0> it is
<2> BooBoo[home]: /usr/sbin/mysqld -V
<5> RolandU: -h
<5> RolandU: and you must not have been looking very hard, it's both in --help and in the documentation
<0> . /etc/init.d/mysql found
<3> shabbs, sorry, I overlooked that, I was looking for something called "server"
<2> BooBoo[home]: ok, run /usr/sbin/mysqld -V to get the version number to make sure it's updated
<6> What was the content I have to add to the config file in Linux to turn of Networking (TCP/IP)?
<2> Cooner750: skip-networking
<6> which file?
<2> !m Cooner750 my.cnf
<7> Cooner750: (Using Option Files) : http://dev.mysql.com/doc/mysql/en/Option_files.html
<0> /usr/sbin/mysqld Ver 5.0.20-standard for pc-linux-gnu on i686 (MySQL Community Edition - Standard (
<0> GPL))
<0> so yes it is
<2> BooBoo[home]: excellent. Now, run /etc/init.d/mysql start
<6> ok. I'm back here at my aunt's house now where the 'server' (PIII 1Ghz) lives
<6> So i can actually change things. I cant seem to get FTP working right or I could change stuff remotely
<0> Starting MySQL................................... [FAILED]
<2> BooBoo[home]: ok. Now let's find the data_dir and the error_dir. Do you have a /etc/my.cnf or a /etc/mysql/my.cnf?
<0> well i didn't
<0> i had to write one so it soo basic
<0> locate would find it but it wasn't there
<2> BooBoo[home]: ok, we need to find one to start with then. Let me find the filename it uses
<2> my-medium.cnf, iirc. You might try a find for that
<0> check this out
<0> http://hashmysql.org/paste/1707
<0> that is my init.d
<2> yeah, that's perfectly fine. Shouldn't need to mess with it
<0> ok i was just reading line 27
<2> please find the my-medium.cnf file so we have a good config file to work from
<0> ok
<2> !tell us about my.cnf
<0> found /usr/share/mysql/my-medium.cnf
<7> But I don't know a thing about that.
<2> perfect
<2> copy that into /etc/my.cnf
<8> You want to use my-freaking-huge.cnf
<0> ok
<8> Or my-gawd-i-have-too-much-ram.cnf
<4> or i-use-enzyte.cnf
<2> BooBoo[home]: now open that file up and locate datadir= and error-log= or something like that
<2> !man server system variables
<7> (Server System Variables) : http://dev.mysql.com/doc/mysql/en/Server_system_variables.html
<1> anyone knows why mysqld not waiting for p***phrase?
<2> log_error
<2> kokoko1: add -p
<1> inviso, where?
<1> imean in which section
<2> kokoko1: which section of what? mysql -u user -p
<1> inviso, i am talking about mysqld script
<1> when I issue service mysqld start
<2> kokoko1: why would it be waiting for a p***phrase?
<1> its can't wait enough to type p***phras
<1> inviso, coz i am using SSL
<2> mysqld doesn't need a p***phrase to startup
<2> ohhhhh
<2> no idea
<1> and my.cnf is told to check for certs
<9> guys,
<0> inviso: not found..
<2> BooBoo[home]: no datadir or log-error in that file?
<0> no datadir= or err in the whole thing
<2> can you pastebin that one for me? Sounds like it's pretty sparse
<0> searched for string err and got override only
<0> http://hashmysql.org/paste/1708
<9> guys, i am trying to run another mysqld instance with a different port and unix socket
<9> but I keep getting A mysqld process already exists
<9> "A mysqld process already exists"
<10> quick question
<9> any clue around it.
<0> mysql_multi ?
<11> ntengineer: are you sure you're using a different my.cnf file?
<9> let me confirm that
<9> hld on
<10> I have model where I can draft it as either a hierarchy linked by foreign keys, or a one model with just a lot of attributes
<10> which way is better
<10> so it's Division > League > Team
<10> or Team with just simple strings representing Division and League in columns
<0> inviso any more ideas ?
<11> mebaran151: ever hear of cj date?
<10> sorry, can't say I have
<2> BooBoo[home]: yeah, give me a sec. check /var/lib/mysql/ for data
<10> what's that?
<8> Who.
<8> He is your best friend.
<10> eskywill, elaborate
<10> (please)
<8> !google cj date
<7> cj date: http://www.dbdebunk.com/
<9> how do i specify which my.cnf to use in mysqld_safe? what is the argument line?
<9> this is what I have so far: ./mysqld_safe --socket=/tmp/mysql5.sock --port=3307 --prefix=/usr/local/mysql
<0> yeah data is in /var/lib/mysql i had old data so i mv'd to mysql.old and some how gopt it to create the dirs
<0> so i have a test and a mysql dir in it
<10> eskywill, any quick answer though
<8> mebaran151, http://en.wikipedia.org/wiki/Christopher_J._Date
<2> BooBoo[home]: perfect. ls -l /var/lib/mysql please
<8> To what?
<10> I have a model I can describe in two ways, that both seem equally good
<2> BooBoo[home]: also, ls -l /var/lib/ | grep mysql
<10> I can describe it as Division > League > Team
<0> paste here ?
<11> !man CONCAT
<8> BooBoo[home], As one line sure.
<7> (String Functions) : http://dev.mysql.com/doc/mysql/en/String_functions.html
<10> or just Team with the League name as a string and the Division as a number
<2> BooBoo[home]: pst me those
<0> what about with 5 sec pauses ?
<8> BooBoo[home], No.
<0> i tried ?
<2> BooBoo[home]: just /msg me with those 3 lines
<0> pm
<8> mebaran151, How do you plan on extracting the info?
<2> BooBoo[home]: if that doesn't work, pastebin them
<8> mebaran151, It really depends on how you access your data.
<10> well I will be basically working at the team level
<10> there is no real business logic at the league or division level
<8> That's the way I'd do it then
<10> just one table then?
<12> whats the top length of a username for SQL?
<8> That would be the easiest based on what you've described. But if you do things like WHERE league IN ('north', 'south'), might be better to store League and Division in a table and join those.
<8> Andy298, 16
<8> mebaran151, Doing it the "better" way is usually better for a reason even if takes longer.
<0> /msg inviso total 32,-rw-rw---- 1 mysql mysql 693 Apr 14 12:57 dhw308.err,-rw-r----- 1 mysql mysql 378 Apr 14 12:09 error.err,drwx------ 2 mysql mysql 4096 Apr 14 11:34 mysql,drwx------ 2 mysql mysql 4096 Apr 14 11:34 test , ls -l /var/lib/ | grep mysql= drwxrwx--- 4 mysql mysql 4096 Apr 14 12:09 mysql,drwxr-xr-x 5 mysql mysql 4096 Apr 14 11:32 mysql.old
<10> well I'm not sure which is better
<8> BooBoo[home],hehe
<2> eskywill/ mebaran151: one table is kinda defeating the purpose of a database. Just use a text file if that's all you're going to do
<10> inviso, well it's more complicated than that....
<0> 1 line csv
<10> this is just part of my webapp
<2> mebaran151: then use tables as they should be used :)
<10> but it seems silly to have a table of just integers
<8> inviso, Na. He could be joining other info.
<2> BooBoo[home]: permissions look good
<10> (the Divisions)
<10> eskywill, yeah
<0> i thought so
Return to
#mysql
or
Go to some related
logs:
php unglobal
mysql uses of self-join
#css
#perl
bytecc ubuntu
close mplayer
le_NEKO
gentoo startx xterm error while loading shared libraries
Pam Kuehling
pipe brekage
|
|