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