| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14
Comments:
<0> ctooley: of course. Very useful
<0> ctooley: simply give each table a different alias. select blah from foobar t1, foobar t2
<1> inviso, there is nothing on syslog
<2> bah! it's still denied
<0> NOthsouth: then look for the mysql error log. /var/log/mysql or perhaps in your datadir. /var/lib/mysql is a common place for it
<3> howdy all, I need to add a field to a table to store a true or false value (essentially I'll have a check box on my form, set or unset), how should I define the field?
<3> just as an INT?
<3> and then just store 0 or 1 in the field?
<0> flakrat: tinyint or enum
<3> inviso: thanks
<2> mm, i have no mysqld process, but /etc/init.d/mysqld start refuses, siting it already started now.
<4> invisio, thanks, worked like a charm
<2> and i'm still getting ACcess denied for 'root@localhost'
<5> if you get access denied that means it's running
<2> so, it denies if it's not running (cant connect)
<2> ?
<0> No, it gives you a socket error if it's not running
<0> ohgood: mysqld is running apparently. If you're trying to reset the p***words given the first set of instructions, mysqld will need stopped first or it won't have any effect
<2> ok. i'll do it all over again then.
<2> ok, now i have a hung shell
<2> this isn't working
<2> i'm still getting Access denied
<5> well then you're not doing something right
<2> i'm following that word for wordd
<2> what can i remove to start over ?
<2> anyone ? what is needed to be deleted to start this over again ? the resetting of roots p***word didn't work, and now mysqladmin denies, just like the other commands.
<2> would re-emerging mysql help this at all ?
<5> ohgood: what OS are you on?
<5> oh emerge
<5> gentoo
<5> delete your /var/lib/mysql/mysql directory and run mysql_install_db
<1> i just delete all my mysql databases, there is any chance to get them back ??
<5> NOthsouth: from a backup
<1> i don't have one
<2> shabbs: ty kindly. is the database visiable with normal text editors, or will is just be a garbled mess ?
<5> ohgood: physically go to /var/lib/mysql and rm -rf mysql in that directory to remove the mysql database
<2> shabbs: done. starting over now. i hope.
<2> ****! it still denies acces!
<5> ohgood: and you ran mysql_install_db?
<2> yes
<5> and you did mysql -u root
<2> yes
<5> no -p?
<2> correct
<5> paste what you did and the error
<2> one sec...
<6> try mysql -u root -p and press return at the prompt
<2> output will go to http://ohgoodgreif.isa-geek.org/~oclv/misc/mysql.txt .... one sec
<2> refresh
<5> ohgood: I meant paste when you are trying to login
<2> about too.. refresh please
<5> along with the full error
<2> ok
<2> mysql # mysqladmin -u root p***word 'whatever'
<2> mysqladmin: connect to server at 'localhost' failed
<2> error: 'Access denied for user 'root'@'localhost' (using p***word: YES)'
<6> ohgood try mysql -u root -p and press return at the prompt
<2> ok-
<2> i have a mysql> prompt
<2> where am i supposed to go from here ?
<6> !man tutorial
<7> (MySQL Tutorial) : http://dev.mysql.com/doc/mysql/en/Tutorial.html
<6> 1man securing
<6> !man securing
<7> (Securing the Initial MySQL Accounts) : http://dev.mysql.com/doc/mysql/en/Default_privileges.html
<8> !perror 134
<7> MySQL error: 134 = Record was already deleted (or record file crashed)
<2> so, i'm still getting denied.
<5> add -p and hit enter when it asks for p***word
<6> so when has -p been required for empty p***words
<2> so, there is no p*** for root again ?
<5> *shrug*
<6> first saw it a week or two ago
<6> on winxp
<5> this is first time I'm seeing it
<8> !perror 144
<7> MySQL error: 144 = Table is crashed and last repair failed
<8> !perror 145
<7> MySQL error: 145 = Table was marked as crashed and should be repaired
<8> yay this is a fun error log
<6> !perror Leithal
<7> Invalid error number.
<2> ok. this makes no sense. if i can't set p***words for users, whatever good is it ?
<8> !perror 127
<7> MySQL error: 127 = Record-file is crashed
<8> Jesus
<9> ohgood: from the sounds of it you're probably best off by removing mysql and starting over
<2> doesn't rm -rf /var/lib/mysql/mysql basicly do that ?
<5> that removes the mysql database, not the entire data dir
<5> emerge --unmerge mysql
<5> then rm -rf /var/lib/mysql
<9> are you using gentoo or ....??
<2> yes, i'm using gentoo
<9> then follow what shabbs said and start from scratch
<3> does this look like the correct syntax to add a new column to my table: ALTER TABLE `customer` ADD eval_user TINYINT UNSIGNED NOT NULL;
<2> bleck. ok. should have done this to begin with i suppose.
<5> ohgood: make sure you do /etc/init.d/mysql stop
<2> shabbs: oh ya, and sync'ing, and rm everything in /tmp/ and a few others while i'm cleaning house. :)
<10> hello
<11> hmm, default mysql memory use in debian is quite obscene
<1> this message apear when I try to start mysql: /etc/init.d/mysql: line 88: /etc/mysql/debian-start: No such file or directory
<12> having some trouble with replication - can't seem to get the slave_IO thread going. Seems like it is a permissions issue, but I can connect manaually.
<12> how can i be sure that the replication slave is establishing a connection?
<13> SHOW SLAVE STATUS; on the slave
<12> ah - bingo --- a restart of the master seems to have done the trick (??)
<12> thanks.
<14> can anyone show me a good sql query if i want to insert multiple rows?
<15> !m netbrain INSERT
<7> netbrain: (INSERT Syntax) : http://dev.mysql.com/doc/mysql/en/INSERT.html
<14> yes. i am aware of the insert syntax.
<14> but is it just insert into tbl values(''), values(), values() ?
<15> values is only onces
<15> values (),(),()...
<14> ok. thanks
<16> hi! i use mysql++. when i insert a record into a table with a auto_increment as primary key; where can i get the value of the primary key in the record just added?
<17> in PHP its mysql_insert_id() 0:-)
<16> hmm, seems to be a c api func too, thx
<18> can I do something along the lines of select field1, (select sum(table2.field1+ table1.field) from table as table 2) field2 from table as table1
<14> uhm, the insert into... on duplicate.. does that trigger when i have a unique index or is it just on primary key?
<0> netbrain: triggers on both I believe
<14> thanks
<0> kuku5: what on earth are you trying to do?
<19> hey all, is there a 'connect by prior' in mysql?
<14> on insert into... on duplicate... can i insert multiple rows with one query through values()?
<0> netbrain: can you?
<0> omi: a what?
<20> netbrain: yes you cn do something like "insert into table SELECT * FROM Other_table"
<14> inviso: yes.. apparanty i can
<0> netbrain: ;o)
<0> All hail the Wisdom of SQL
<0> !tell us about tias
<7> inviso asked me to tell you this: TIAS: Try It And See. You look silly asking if something will work when you can just try it and see. This channel is not a MySQL server ;-)
<19> inviso, take a look here http://www.devx.com/tips/Tip/14362
<19> I was curious if such functionality exists in mysql
<19> I'm using 4.1.15 at the moment
<0> omi: ouch. That's bad design. Take a look at the follow docs for a better way to structure hierachical data
<0> !tell us about trees
<7> inviso asked me to tell you this: Trees in SQL: http://www.dbazine.com/oracle/or-articles/tropashko4 and http://www.sitepoint.com/article/hierarchical-data-database, http://jan.kneschke.de/projects/mysql/sp/ and
<7> http://www.vbmysql.com/articles/managing-hierarchical-data-in-mysql.html
<19> how is it bad design?
<0> omi: it's impossible to query efficiently. I don't know what connect by prior does internally, but it still has to be fundamentally recursive
<19> I think it is a semmantic magic that does the recursive union
<0> keyword: recursive. It's gunna bite
<19> but how am I going to build up a hierarchy?
<0> make a stored procedure if you want to replicate the behavior but you'd be better off making a small change to how you store the node id
<0> that's what those docs explain
<0> really quite nifty although it may take you 2 or 3 reads to "get it." :o) Takes a few times to click
Return to
#mysql
or
Go to some related
logs:
#ai
concatenate pdf ubuntu
#physics
#css
ati_agp ATI 200M
#math
#web
#debian
PHP6 short_tags
qdb bot
|
|