| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> hello, i'm trying to run mysqladmin server but: "mysqladmin: Error starting slave: The server is not configured as slave, fix in config file or with CHANGE MASTER TO" . I'm using debian and all packages was installed automaticly. HELP ?
<1> server id not specified.
<0> where is the config file ?
<0> what i need to do ? is first time when i trying to use mysqladmin .
<2> another... debian user
<2> :/
<0> yes...another idiot who can't config the mysqladmin server :((
<2> no
<2> another victim of debian fukked up packages
<0> ... :)
<2> I am getting sick of debian
<0> so... frank- can you help me please ?
<2> I don't know about slave servers
<2> are you using repliaction?
<0> i'm trying jut to install MySQL Admin - server. I want to manage my database from my machine using windows & MySQL Administrator.
<2> sorry, I've never done that
<2> I use the linux mysql console
<0> ok :) thanks. I check my luck on #debian :D
<2> thanks
<2> I forsee you getting banned, however
<3> hello
<3> I have got several `-rw-rw---- 1 mysql mysql 1073741964 Mar 22 12:03 ses0248-bin.000007` files in mysql dir
<2> hi
<3> what are they for?
<3> ahha - binary logs :)
<4> limit has to come after ORDER by right?
<2> yes
<2> I forgot to mention that
<5> hi.
<2> hi
<5> I want to imrpove my database designing skill any advice ?
<2> get a course?
<2> read a book?
<5> hmm i found some about sql language
<5> but I mean schema
<5> well no course in my country and I dont like online ones
<2> get a book then
<5> hmm. any advice ? I mean as name of book. I just want to import design part. not commands etc. i checked a few parts but there were only commands and query methods and other unwanted topics were it
<6> google for database design or look on amazon.com
<4> if you are going to have multiple WHERE parts do you just put them one after each other, like WHERE id=1 bo=2 etc
<6> daum: use AND or OR
<6> WHERE id = 1 AND (bo = 2 OR bo = 1) etc
<4> shabbs, thanks
<7> anyone here use Middlekit?
<7> hwo can i ping a server from a client session
<8> how can I use a column alias in a WHERE clause? I have SELECT MATH_EXPRESSION() AS foo ... WHERE foo > 0 and mysql says foo is an unknown column
<2> no
<2> foo is not a column alias in this case,
<2> it's the result from a function
<2> and you cannot use it in the where clause.
<8> is there any way I can use it?
<9> HAVING
<0> ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO
<0> how can i create a slave ?
<2> I guess those debian guys were not helpful
<2> I figured as much
<0> yes...not helpful "debian guys"
<0> mysql> show slave status;
<0> Empty set (0.00 sec)
<4> ORDER BY column ASC would make it order it via the column in ascending order right?
<10> yes thats default
<2> DESC is the other option
<11> How to generate documentation in storage/ndb/docs ? there is no Makefile generated - automake needs configure.ac -- i have doxygen installed.
<12> Hi
<12> we have a postnuke Forum with quite a big mysql database. As we're changing provider and server, I'd like to ask if it's possible to export it from the old server and import it into the new one?
<13> Are you staying with Postnuke?
<12> Pathway, yes, we would like to keep the same forum
<13> Are you keeping the same version of postnuke?
<12> yes, everything should stay as it was!
<12> it's just the server that changes
<0> how can i create a slave ? (in mysql) - 1) "mysql> show slave status;" 2) "Empty set (0.00 sec)" . Help me pleaaase !!...
<0> ERROR 1200: The server is not configured as slave, fix in config file or with CHANGE MASTER TO
<13> Then it won't be too difficult. I recommend you make sure and do a mysqldump of your database, and keep that copy. Then, you should install your new postnuke, and let it make the new database. Then, inport the old database (I use phpmyadmin to do this).
<12> do i have to do that table per table, or can I do the whole database at once?
<12> i use phpmyadmin as well
<2> tziku: http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
<2> tziku: first hit on google, please do not ask questions before using google.
<13> I'd just dump the whole database. Actualy, I'd dump all the databases, and keep it as a backup.
<0> frank- i an "novice" at mysql i found this link 10-20 min ago...but i don't know how to do..
<2> did you read it?
<14> Is it possible to sort a table by the number of times it's ID is listed in another table?
<12> Pathway, thank you. I'll have a look at it and all those settings! :)
<13> help: I'm trying to fix a broken mysql database. The root p***word appears to be set, but I don't know it. There are no other users. I'm attemping to start mysqld with the --skip-grant-tables option... but when I try to set the p***word for root, it says that table myslq.user doesn't exist... Is there some other place where this may be?
<15> quad_: not sure but it would require some kind of group by and count function I'd suspect
<2> !m Pathway reset root p***word
<16> Pathway: (How to Reset the Root P***word) : http://dev.mysql.com/doc/mysql/en/Resetting_permissions.html
<15> Pathway: are you follwoing the procedure for recovering from a lost root p***word in the manual?
<13> frank: Aaah... I saw that page, but didn't look far enough down... I only saw windows instructions. Thanks, I'll come back if I can't get this to work. Thank you.
<2> np
<15> The mysql manual has gotten to be so good in the last few years it's not funny
<17> so marginal documentation is funny?
<18> fo realz dawg
<15> Mike: only as a spectator sport. As a participation sport it ****s.
<14> mikere, yes, almost got it... I cant remember, but how do I use the COUNT() to acumulate the number of times a rownumber is listed?
<15> quad_: I think it interacts with the group by so count(mytable.myfield) and group by mytable.myfield might do it - just a guess on my part.
<2> count(colid)
<13> frank, mikere: thanks, the instructions worked great. I appreciate it. Fairwell!
<2> Pathway: great
<14> mikere, in my test table, i have two rows with ID=1 and one with ID=2, how do I select with an AS (or something) so i can sort by it......
<14> mikere, ill try to work someting out with the count()
<14> mikere, i do belive however, that i need to make a colum with the acumulated numbers, because a simple count() gives me: #1111 - Invalid use of group function
<15> quad_: try showing us the query you are working with right now - might be instructive
<2> of course
<2> you can group on a calculated result
<14> mikere; http://pastebin.com/623739
<14> there i tried to count() on the order clause, and it complained.
<2> err
<15> quad_: and you want to ORDER BY count(groups.id)?
<2> you can't
<2> typo on my part
<14> no mikere, as mentioned, I tried that.
<14> And it gave me: #1111 - Invalid use of group function
<2> quad_: you can't
<19> What you want is the count as part of the result set, then use that column in the ORDER BY.
<15> ah
<14> yes crrj, i thought so, but how excactly do i code that?
<14> something involving an AS clause, right?
<19> one second, waiting for pastebin
<14> rgr
<2> having?
<19> http://pastebin.com/623746 <-- example that I tested on one of my own databases
<14> thanks crrj! - is the INNER vs. LEFT JOIN important?
<14> (im not sure what the diff. is)
<19> INNER vs LEFT dictates the type of results you get.
<19> !man join
<16> (JOIN Syntax) : http://dev.mysql.com/doc/mysql/en/JOIN.html
<14> Ohh its 'left' like in
<14> "whats left" not in "left side"
<14> :D
<19> It's worth taking the time to learn about the various kinds of joins and how they work. You'll use them a lot in SQL.
<1> various kinds?
<1> as if there are many :))
<20> Well, there's at least 4 in MySQL ;)
<1> or rather... two.
<1> others just syntactic sugar
<20> INNER, OUTER, LEFT, RIGHT...there's 4 :)
<1> left and right are both outer joins
<1> that behave in same way
<20> yes
<20> but FULL OUTER is different from a RIGHT OUTER
<1> it isn't supported! :)
<20> ahh
<20> I'm a MSSQL user being forced to use MySQL :(
<1> is that bad? :)
<1> you should be eager to use mysql!!! :)
<21> yeah, don't be a communist
<2> MSSQL has a lot of quirks
<2> I would rather use mysql, especially now that it's a lot more full-featured than say, 2 years ago
<21> unfortunately, you're wrong :/
<21> but keep thinking that :p
Return to
#mysql
or
Go to some related
logs:
#bash
mplayer dumpstream
#perl
#freedesktop
#bash
#perl
azureus ShareResource: Torrent create failed
dapper communicate stx
#php
scisoft ubuntu
|
|