Demeter: Regedit: the built-in thing is a fulltext index. External libraries are Lucene and Sphinx.
Hesseltine: Ester90n: set log_warnings=2, then they will be in the error log.
Urtz: Snoyes: I tried it but no result. When i check dev.mysql.com it says that it is possible only mysql 5.5 or later so i will update it or build it from source. thank you
Coffell: Oh, I didn’t check the version.
Christman: Manross: yeah it is old but i always prefer base repo on centos
Ocana: I think the best solution is building mysql from source.
Hamm: No that is not the best solution.
Hamm: Try using IUS MySQL 5.5 or 5.6 if you want a more recent version
Varieur: Naftilos76: it allows all possible global and database privilege.
Lamborn: Varieur: do you know if all these privileges are the ones i get if i query “show privileges” ? I get 31 privileges.
Varieur: Naftilos76: why do you ask?
Melendrez: Varieur: because i am building a control panel that manages mysql database in a much more easy way to configure than phpmyadmin!
Leahman: Varieur, i do not like php. I do it the rails way :
Varaza: Varieur: can you pls confirm the term “global privileges” ? Global privileges are one or more or even all of the available privileges provided by mysql as long as they are ***igned to a user for ALL databases?
Equiluz: Can anybody else confirm ?
Quintanilla: Hello, i have been working with a mysql db in php, but i have saved utf8 characters as latin1 in utf8 table. This answer solves my problem 50/50: http://stackoverflow.com/questions/9407834/mysql-convert-latin1-characters-on-a-utf8-table-into-utf8 but some data is in perfect utf8 encoding and they are destroyed by this script. Can i detect encoding and only run the “fix” on buggy rows ?
Newborn: Varieur, are you busy?
Remfert: Naftilos76: yes, global privileges means applies to all databases, plus some that are not database-specific, like SUPER and FILE
Kozyra: I have lots of vhosts/websites, they mysqld seems to be using a lot of HDD due to having ~150 sites/DBs, my RAM utilization is 50%, what tweaks can I use to turn on more caching options?
Coklow: How can i find all rows where firstname does not contains any of: æøåÆØÅ ?
Balckwell: Jd: See http://dev.mysql.com/doc/refman/5.6/en/regexp.html
Manderscheid: I’m trying to use sqlfiddle to built my schema, but i’m getting the following error “You have an error in your SQL Vasko; check the manual that corresponds to your MySQL server version for the right Vasko to use near ‘varchar52 COLLATE utf8_unicode_ci NOT NULL, twitter_id bigint NOT NULL, twitte’ at line 1”
Nailer: Anyone have any ideas?
Billue: Disregard, i can build the table in a different way!
Varieur: DAM9779: what’s before varchar?
Eckols: DAM9779: Use around identifiers database/table/column/alias names and ‘ around strings and dates. MySQL does allow ” for strings, but ANSI standard uses ” for identifiers which you can enable with ANSI QUOTES option.
Caulfield: Ok, trying now, thank you!?
Manross: DAM9779: easier for us if you pastebin the entire sql and the entire error message
Haakenstad: Really, Manross the chan title made it sound like sqlfiddle was the recommended way.
Manross: DAM9779: and you didn’t provide us with the link to it
Chilcoat: Here’s the error i’m getting, i’m trying to add around all tables and columns, right?
Arakaki: God i **** at this http://pastie.org/10403678
Rivadulla: Ok, here’s the issue i’m having. I’m trying to find a query to find come up with a score board. You can have one player answer multiple times, but would want them all groupped together, this http://sqlfiddle.com/#!9/1c915/2 works great when you have distinct players, but it doesn’t work when you have the same player answering multiple games http://sqlfiddle.com/#!9/a39955/2.
Dashno: DAM9779, better? Your data is way too wide to be read to be honest. http://sqlfiddle.com/#!9/1c915/5/0