| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> err
<0> try cd /usr/local/mysql
<1> file doesn't exist
<2> type cd /usr/local
<2> and then ls
<1> no mysql dir listed
<2> sure you installed it?
<1> it came with entropy.ch
<1> and php says it's installed
<1> I will go download it to make sure ;)
<2> k4st, perhaps entropy installs elsewhere
<3> Where can I get a intel native version of mySQL for OSX?
<4> your database is empty.
<4> can someone help me install wr timetracker
<5> ACE_Block_Pool( size_t max_data_size ) :
<5> _max_data_size( max_data_size ),
<5> oops, sorry!
<5> hit ctrl v by accident heh :)
<6> hello all
<6> i have installed mysql server 5
<6> but when i try to start using init script it give me this error
<6> Starting MySQL ERROR! Couldn't find MySQL manager or server
<6> but when i start using safe_mysqld its work fine
<6> what to do ?
<6> any one
<6> ?
<7> greetings
<6> can any one help me with this ?
<6> Starting MySQL ERROR! Couldn't find MySQL manager or server
<6> i am getting this
<7> I have an intermittent problem connecting to an MySQL server
<8> patience is an virtue.
<7> the same mysql -h <host> -u <user> -p sometimes connects and sometimes gives me error 111
<7> what could it be?
<9> !perror 111
<10> System error: 111 = Connection refused
<8> Maybe you are at max connection something?
<8> Maybe you are at max connections?
<7> nope, it's a test server, no connections at all
<7> and works fine from other machines, just this one
<8> :X
<7> it's an A64 but it shoudln't matter... should it?
<8> shouldnt i guess
<7> is there some debug mode to see wht is the connection refused?
<7> *why
<8> dunno, maybe there are logs somewhere, i dont really know
<7> fsck!
<7> hostname resolves to two addresses
<6> how can i fix init.d script for mysql 5
<6> ?
<8> lol
<8> ul |RABBIT|
<11> greetings everyone, i have a quick question, i am trying to use mysqldump to do a backup of multiple tables, and the way its currently doing it is for tbl1, tbl2, etc in a loop mysqldumb [opts] tbl1 > tbl1.sql one right after the other. this is fine, but i am concerned about the possibility of having one table locked while another is being written to
<12> anybody can recommend a php chan
<11> so intead of LOCK tbl1 -> Dump tbl1 > tbl1.sql UNLOCK tbl2 LOCK tbl2 -> Dump tbl2 -> UNLOCK tbl2...etc
<13> besides #php ?
<11> i would like to do
<11> "LOCK tbl2, tbl2, tbl3" -> Dump tbl1 > tbl1.sql, dump tbl2 > tbl2.sql ... -> UNLOCK tbl1, tbl2,,,
<11> can this be done from the command line ?
<12> sneaky: i dunno is that where u go for help?
<14> what is wrong with this: http://rafb.net/paste/results/hLj6UU14.html
<11> i can only get mysqldump to generate one output fro all the tables, but i need each individual table
<11> anyone ?
<15> hello
<16> jcarroll, huh?
<16> !tell us about whats wrong
<10> will asked me to tell you this: Don't ask us "What's wrong with this query...". We are not SQL parsers. We do not care to look character by character looking for errors when MySQL will tell all of us WHERE the error is. Paste the FULL error issued by MySQL.
<16> What's the error message?
<16> Reading them helps
<11> will
<16> jcarroll
<11> i am trying to backup several tables their own <tableName>.sql using mysqldump
<16> oh
<16> !m jcarroll mysqldump
<10> jcarroll: (The mysqldump Database Backup Program) : http://dev.mysql.com/doc/mysql/en/mysqldump.html
<16> That will show you how, if possible.
<11> however, instead of putting a for loop around mysqldump and having each table be locked, dumped, unlocked one after another
<11> (ive been there_
<16> So you know if it can be done or not...
<11> i want in one statement, to mysqldump,,,lock relivant tables, dump to tablename.sql -> unlock all tables
<16> You can't always have what you want.
<6> can any one help me with mysql init script for mysql 5 ?
<16> What's wrong with it?
<6> well it will give me erros
<6> me errors
<16> Like?
<6> ERROR! Couldn't find MySQL manager or server
<6> when i give this command
<6> service mysql start
<6> any idea
<16> Nop
<6> :(
<17> Leave out "ASC" -- good or bad practice?
<6> hey
<6> i have fixed startup issue
<17> Bring out the champagne.
<1> is anyone here using mysql on osx?
<1> I've got it installed I just don't know how to access it
<18> mysql -p
<1> typing that into the terminal said the command doesn't exist
<17> Leave out "ASC" -- good or bad practice?
<13> obviously you don't have the mysql client installed
<1> I just installed it and it's in /usr/local/mysql
<1> I just installed the .dmg from mysql.com, it said it was installed.. I typed that thing in the terminal, but only that, am I missing something?
<1> I'm new to macs, so I think I'm missing something
<19> Arg - you guys were right last night - an subselect just bit me in the butt! Anybody able to suggest optimizing my subquery to remove an inner "NOT IN" subquery? Here's the paste: http://hashmysql.org/1507
<19> Typed what thing in the terminal?
<1> mysql -p
<19> try /usr/local/mysql/bin/mysql -p
<19> I haven't gotten around to adding it into my PATH yet...
<1> that worked
<1> do you know what the default p***word is?
<19> Actually, there isn't one.
<19> ditch the -p on the end.
<18> or press enter :P
<19> or that.
<1> well, I put nothing in, press enter and it says that it can't connect to local MySQL server through socket 'tmp/mysql.sock'
<19> try /usr/local/mysql/bin/mysql -uroot
<1> trying everything gives me the socket error
<18> so mysql isn't running?
<18> try netstat -a | grep mysql
<1> okay, I think it did something, no errors returned
<1> so, try the previous stuff again?
<18> hehe, that means mysql isn't started :P
<1> did that command start it or just check to see if it was started?
<18> you should probably start it the macosx way.
<18> just check
<1> oh, er, how?
<18> dunno :/
<19> Click on System Preferences.
<19> in the Other section, do you see MySQL?
<1> nope
<19> OK, you might want to go back to mysql.com and look for the Mac OSX preferences pane
<19> or just type /usr/local/mysql/bin/mysqld &
<1> oh wait, I know where that is
<1> I just wasn't sure what to do with it
<19> make that /usr/local/mysql/bin/mysqld &
<1> I will click it
<19> dobule-click the ****er.
<19> clicky-clicky.
<19> boom.
<18> o_O double click? you can do that on a mac?
<1> mysql is now running :D
<19> hell, you can quintuple-click, if you're fast enough.
<19> Yipee. now go back and do the /usr/local/mysql/bin/mysql -uroot
<19> Or, just download the MySQL Query Analyzer from mysql.com
<1> I'm in :D
<19> most excellent.
Return to
#mysql
or
Go to some related
logs:
jquest libsdl
451 qq temporary problem gentoo
ioctl: LOOP_SET_STATUS: Invalid argument, requested cipher or key length (256 bi
#css
Suse dual head no cursor
#linux
#lisp
java-config package conflicts
wayttd ubuntu
binary downloader debian
|
|