So, every now and then you may want to have a table or some sql query as a csv or excel file to be able to do certain tasks like graphing etc.
Here a quick way to get that.
mysql -h Host -uUser -pPassword -D Database -e 'sql query;' | sed "s/'/\'/;s/\t/\",\"/g;s/^/\"/;s/$/\"/;s/\n//g" >MyFile.csv
Continue reading “How to create a csv or excel file from a mysql query”
It is not unusual for bin file to fill up the partition for mysql when one is doing master-slave replication.
Ideally one should have a reasonable setting in the my.cnf file. Setting the expire_logs_days to something reasonable or the max_binlog_size to a size you one can leave with.
In the case where one missed the opportunity to do so at the setup time and one cannot afford to change this and do a restart. two commands come in handy. One will reduce to the file desired and the other will reduce the bin files to the desired date.
Continue reading “How to Reduce mysql bin files on-the-fly”