Category: MySQL

Oracle and Sun

MySQL, Diverse Send feedback »
On Oracle web site "Oracle and Sun" page has changed:There is also a PDF file for downloading... About MySQL it mainly says:What are Oracle’s plans for MySQL?Oracle plans to spend more money developing MySQL than Sun does now. Oracle expects… more »

ssh tunnel - to a server by custom port

Linux, Fedora, MySQL Send feedback »
If you don't want to make holes in your firewall because it would looks like "swiss cheese"... more »

show variables like 'ft_stopword_file';

MySQL, L10n Send feedback »
For a long time the ft_stopword_file variable was a poorly documented feature.According to Wikipedia:stop words is the name given to words which are filtered out prior to, or after, processing of natural language data (text). more »

Amout of uniqueness

MySQL Send feedback »
Following my old post from 2008 I give you once again the query to verify the amount of uniqueness of a column: SET @firstXchars = 2; SELECT COUNT(*) AS `total values / NULL`, COUNT(DISTINCT column_name) AS `distinct values / distinct lef… more »

Mysql dump - Extract databases as files from a full dump

Linux, CentOS, MySQL Send feedback »
for DB in `grep "Current Database:" all-databases.sql | replace "-- Current Database: " "" | tr -d "\\\`" `; do sed -n "/-- Current Database: \`$DB\`/,/-- Current Database:/p" all-databases.sql > ${DB}.sql; done Complicated... yes.. you're right. Let'… more »
Contact. ©2010 by Gabriel PREDA. blog software / hosting.
Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.