Wrobleski: Dtrainor: Maybe there’s a security module involved, like selinux.
Deason: ChrisWJ: did your dump include the mysql database and is the dump from the same major version of mysql?
Slodysko: Ah. Yes. It did and yes it is.
Cavagna: No successful change master though.
Prakoth: It’s inside of a docker container. this is my first hack at docker. i don’t see anything in the logs that would indicate that there is something amuck, though.
Deason: ChrisWJ: did you empty the datadir before import?
Deason: ChrisWJ: odd, did rm+reset all fix you up?
Wipf: Deason: moving master.info reset slave all still throws the server-id error.
Deason: ChrisWJ: try skip-slave-start in my.cnf and a restart, then reset slave all again
Maffey: Weird, not even this does as I expect it to do: /usr/libexec/mysqld –verbose –help –defaults-file=/etc/my.cnf
Adami: How to get minimum id of post without subquery, something like SELECT * FROM posts LIMIT 0,10;
Hendricks: Without adding SELECT MINposts_id FROM ELECT * FROM posts LIMIT 0,10 tbl.
Bordas: OnceMe: If you have sufficient data to uniquely identify each row properly, you can use an outer join to find 10 rows. There are other approaches. See discussions of rank.
Keithley: I dont have info what posts_id will be showed
Osle: There are based on score
Voskamp: OnceMe: Your logic has nothing to do with score.
Martich: OnceMe: Try asking the real question and don’t worry about subqueries.
Deason: ChrisWJ: after setting server-id + skip-slave-start in my.cnf and nothing with “relay-*”, when you then issue “reset slave all;” you get “Slave is not configured or failed to initialize properly”?
Eisler: Is mysql_stmt_bind_param is slow if i want to call it every time before execute the stament for many records?
Polee: OnceMe: If you’re using some ORM that has a limitation, ask about that limitation in the #orm channel.
Deason: ChrisWJ: not sure what else to poke, off hand, besides doing something drastic like cleaning the datadir or using strace
Mayr: How can I re-write this: http://pastebin.com/P6LpndRs so that it works?
Goswick: Catuca: what are you doing
Kraasch: Catuca: you probably want to do ‘AND . REGEXP .’
Tupper: Domas: I want to match the left column under regex with the right column
Vanschuyver: You want to extract a string and use it for matching?
Gabbin: Domas: For example, wb.domain would be like ‘domas.test.com’ and wu.display_name would be ‘domas’. I want to run a regext on wb.domain before matching it to wu.display_name
Davia: Catuca: https://github.com/mysqludf/lib_mysqludf_preg
Mucklow: You need PREG UDFs for that
Kegerries: Catuca: and yes, MySQL should’ve had that functionality ages ago!
Brigg: Domas: I can’t mess with the server installation
Rissler: Catuca: then you can’t do this
Lucca: Domas: is that what it would require? I will just write PHP code to do that
Gombert: Catuca: you can execute your join manually in PHP then
Anklam: Domas: the alternative would be writing a stored procedure
Hookano: Catuca: if you can write one!
Rael: Because you’d still need to extract the substring
Knetsch: And there’s no easy way
Bendzus: UDF is your best option
Dings: Catuca: alternative is pre-materializing the substring in a separate column
Wethern: Thats database-y alternative
Lebert: What you put in a variable
Wynne: It doesn’t extract a substring anyway
Kemme: I know I am right, I’m always right
Lebitski: Domas: I wouldn’t be able to do a REGEX on the column then?
Palas: Read the conversation we had five minutes ago