#mysql
22 October 2007
Total 24 pages. You are browsing page 5/24.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last
06:29 <****> fitoria: finish it
06:29 <****> ok
06:29 <****> litheum: how come i could use show binlog events from the master
06:30 * chadmaynard has a new understanding of the unknown
06:30 <****> Assid: because those were events in the binlog. they're not events in the binlog on the slave, they're in the realy log
06:30 <****> Assid: you shouldn't be using show binlog events, anyway. http://dev.mysql.com/doc/refman/5.0/en/show-binlog-events.html
06:31 <****> litheum: okay help me out here.. i cant get mysqlbinlog to do whats required..
06:31 <****> maybe its PEBKAC .. due to lack of sleep
06:31 <****> what is "required", and what is it doing contrary to expectations?
06:31 <****> and why are you doing this without having had enough sleep?
06:31 <****> that can't be a very good idea ;)
06:32 <****> litheum: dunno.. i mgiht have to visit the doc...
06:33 <****> body is feeling a bit weird today.. just not myself
06:33 <****> got 3 hours of sleep
06:33 <****> ...
06:33 <****> litheum: slave status i think is stuck .. Last_Error: Error 'PROCEDURE mydns.sp_createzone does not exist' on query. Default database: 'mydns'. Query: 'drop procedure sp_createzone'
06:34 <****> but the reas master log position is the same as the master
06:34 <****> Assid: it's not stuck.. you tried to drop the procedure, but it didn't exist on the slave, so it casued an error, and it stopped
06:34 <****> so, skip that statement
06:35 <****> litheum: got that from show slave status.. still havent figure out mysqlbinlog
06:35 <****> all you gotta do is run mysqlbinlog and give it the filename of the binary log you want to inspect
06:35 <****> it will be a relay log on the slave
06:37 <****> okay got it
06:37 <****> dont see an error
06:37 <****> Assid: there wouldn't be any error *in* the relay log; the error occurs when the slave sql thread tries to *execute* the relay log
06:37 <****> i see the procedure creation in the relay log.. but doesnt seem to be executed
06:37 <****> # at 464869
06:38 <****> #071022 0:19:28 server id 1 end_log_pos 464971 Query thread_id=252 exec_time=0 error_code=0
06:38 <****> is that before or after the position of the slave?
06:39 <****> thats the line AFTER the query was executed on the slave
06:40 <****> chadmaynard: check it now please http://paste.ubuntu-nl.org/41637/
06:40 <****> another thing could you help me in what to put to do my comment
06:41 <****> okay this is funny.. why is my relay log having other database queries which arent supposed to be replicated?
06:41 <****> relay log will contain statements even if there are replication-* rules that exclude them... they will simply be ignored by the sql thread
06:42 <****> if you have binlog-* rules to exclude certain databases/tables, those will not be saved to the binlog at all, and will thus not be replicated
06:42 <****> okay apparently the log position is set before the SQL query not after.. so according to this..
06:42 <****> chardmaynard??
06:42 <****> slave has "#071022 0:11:21 server id 1 end_log_pos 463461 Query thread_id=246 exec_time=0 error_code=0"
06:43 <****> #071022 9:41:43 server id 1 end_log_pos 464730 Query thread_id=246 exec_time=0 error_code=0
06:43 <****> thats the master below
06:43 <****> could anybody help me in this http://paste.ubuntu-nl.org/41637/
06:43 <****> check the comment
06:44 * Buglouse [Buglouse's File Server is online] [Note: Use this as a privilege and not as a right] [New: Movies. Music. Appz. More.] [Triggers: /ctcp Buglouse Movies, /ctcp Buglouse TV, /ctcp Buglouse Music, /ctcp Buglouse Appz, /ctcp Buglouse Docs] [Accessed: 3 time(s)] [Files sent: 1 file(s)] [Bytes sent: 26.45MB] [Failed sends: 1] [Bans: 0] [Queues: 3/15] [Max CPS: 39.31KB by smkndoobies]
06:44 <****> wow, way to get k-lined
06:46 <****> yeah
06:46 <****> litheum: any idea
06:47 <****> litheum: i think the mysql version has a problem
06:47 <****> could anybody help me in this http://paste.ubuntu-nl.org/41637/
06:47 <****> check comment
06:47 <****> cause if im not mistaken when i had 2 slaves (the one thats master now) used to replicate the stored procedure
06:47 <****> i never really checked the other one
06:49 <****> could anybody help me in this http://paste.ubuntu-nl.org/41637/
06:49 <****> bah i think i need to sleep soon.. im starting to see circles
06:52 <****> wait, these circles... are they interconnected?
06:52 <****> could anybody help me in this http://paste.ubuntu-nl.org/41637/
06:54 <****> thoughtful: nah.. random
06:55 <****> and worse still hurts near the edge of the eye (inwards towards the nose)
06:58 <****> Assid: sinus headache?
06:58 <****> sounds like a sinus headache to me
06:58 <****> how can i have mysql tell me the key it used for the insert i just did?
06:58 <****> thoughtful: nah.. sinus aint hurting otherwise
06:58 <****> its just the eyes
06:59 <****> no runny nose or anything
06:59 <****> i think its the lack of sleep
06:59 <****> thoughtful: last_insert_id()
06:59 <****> fitoria: hmmm?
06:59 <****> worse still im trying soo hard .. i might actualy just get a sleeping pill.. which ive never done in my life
07:00 <****> http://www.conclase.net/c/mysql/index.php?fun=LAST_INSERT_ID
07:02 <****> oh - that must be for me, fitoria?
07:03 <****> or maybe just coincidental :) .
07:03 <****> no for thoughful
07:03 <****> it looks like what i was looking for too.
07:03 <****> XD
07:08 <****> could anybody help me in this http://paste.ubuntu-nl.org/41637/ check comments
07:20 <****> hi all
07:20 <****> could anybody help me in this http://paste.ubuntu-nl.org/41637/ check comments
07:21 <****> how can i remotely connect to mysql server through mysqlyog - i just installed mysql 5v on server(machine)
07:22 <****> do i need to write localhost in my host name
07:22 <****> Abdul: not if it's a remote server, you'll need to put in the name of the server.
07:22 <****> ok thx let me try
07:22 <****> localhost means 'the computer the program is running on'
07:23 <****> fitoria don't you need an END IF;
07:23 <****> yes
07:23 <****> XD
07:23 <****> nops - its says host IP is not allowed on MySQl server
07:24 <****> xolax but i need the syntax to not insert
07:24 <****> look comments
07:24 <****> fitoria: I don't see that you can use IF there
07:25 <****> fitoria declare a variable and set it
07:25 <****> rince i am comaring 2 prices
07:25 <****> if condition = true do nothing
07:25 <****> else
07:25 <****> do i need to put server(PC) name in mysqlyog host field
07:25 <****> do not insert
07:30 <****> Abdul: no, you need to give your username permission to connect remotely.
07:31 <****> Abdul: When you create users in mysql you have a "host" field. You need to add either '%', which means anything (does not include localhost), 'localhost' (which will only allow connections from the server) or the IP address of your computer.
07:40 <****> robot_terror_: yeah, had a small malfunction ;)
07:41 <****> was worried that the TSA had detained you again ... :-)
07:49 <****> how would i get the last hour out of a timestamp column?
07:50 <****> select * from table where timestamp = ??
Total 24 pages. You are browsing page 5/24.
First :: Prev :: [...] [3] [4] [5] [6] [7] [...] :: Next :: Last