Clyatt: Tylak: Some of the INT types and store values one per row

Wardwell: Hmmm, interesting. Haven’t used BLOB yet

Karathanasis: Salle: That’s kinda it. but the limit isn’t really doing anything. I want to only look through the past 5 logins

Sprow: Salle: *nod* Depends on where he places that logic.

Monty: How do i export my database table to multiple csv’s based on the column name

Deason: DrkCodeman: select into outfile

Landsaw: Will that do all of them based on the column names?

Deason: DrkCodeman: computers do what you tell them to, generally

Gustavson: Decoux: Sorry, I have no idea about that manual entry.

Wittie: Reading into iti mgriffin

Venezia: There’s no way to do it in one p*** from inside mysql, though, if that’s what you’re looking for.

Venezia: You could write a quick script to do it, or do multiple p***es

Spickler: There’s, init_connect

Ruge: Oh wait, wrong channel

Venezia: Set global init_connect=’select “output to a bunch of files, jerk!”‘;

Purvis: Starting a server with: mysqld –bootstrap –datadir=. –basedir=. –bind-address=127.0.0.1 –port=10002

Hatto: But it’s not listening on 10002

Gidwani: Why are you binding localhost?

Schechter: I”m trying to p**** the binlog in python, and inet6_aton is causing issues because it replicates binary and the python cries when it can’t decode it as utf-8

Dwellingham: Is there a way I can make it replicate the function?

Birchler: How do I export data to csv by catagories listed in the column “sic_code_description” from my table “busemail_ca_1formatted”

Bachinski: DrkCodeman: can you write a SELECT query that will return the resultset you want?

Bachinski: DrkCodeman: do that first, then worry about the export

Riccio: Gidwani: I just need a local server for testing

Sagar: Like i want to take everything that has “Abrasive Products” in the column “sic_code_description” to it’s own file

Cruce: DrkCodeman: See http://dev.mysql.com/doc/refman/5.6/en/select.html

Bachinski: DrkCodeman: you probably won’t find anyone here to spoonfeed you. show us what you’ve tried and the results in a pastebin

Bachinski: DrkCodeman: or maybe hire someone

Resto: Hi folks, I’m noticing an oc***ional deadlock. This is part of the output from show engine innodb status. http://hastebin.com/vayelegova.vbs

Deason: Theduke: i would be surprised if bootstrap binds a network port and should exit very quickly

Poyner: What would be a fix that makes sense? The quota table and quota_profile have almost no updates. the quota_profile only has selects, the quota table has some selects and some inserts.

Davenport: DrkCodeman: The X-Y problem is when you want to do X, but you don’t know how. You think you can hack X if you can just do Y, but you don’t know how to do Y either. You ask us for help with Y. We think Y is a strange problem to want to solve. So just ask us about X.

Desorcy: Theduke, –bootstrap in the manual says that it is not starting a full mysql server. if that’s the case why would it be listening on anything

Deason: Theduke: anyway, you can also use the unix socket for your dev/test. you should be launching mysqld_safe not mysqld. i would just use a sandbox tool like mysqlsandbox or dbsake

Barranger: Deason, thanks, those changes with the innodb plugin stuff appear to have made a diff, no more growing in times for inserts of batches of 100,000 rows :

Boike: More to read up on now, but happy days so far

Bachinski: Robsco: hey, great news

Stecklair: I have a varbinary16 column that stores ip addresses from inet6_aton — my python script reading from the binlog exits when it hits this due to UnicodeDecodeError: ‘utf8’ codec can’t decode byte 0xae in position 460: invalid start byte

Moriarity: If I change the collation of that column from NULL to utf8_general_ci . will that fix it / is that even safe?