A chronological documentation test project, nothing serious, really!
This post describes my workflow in recovering data from defective harddrives. These harddrives are usually not readable in Windows and in most cases not even readable or mountable in linux as well. One of the great things with linux is all the tools that are available, just do a Google search and you find forum […]
This is just a short post describing Zimbra distribution list (mailinglist) commands. These commands should be run as the zimbra user # su – zimbra List all distribution lists # zmprov gadl Print only members addresses of a distribution list # zmprov gdl mailinglist@example.com | grep zimbraMailForwardingAddress: | awk {‘print $2’} Show if a list […]
This is how you can backup you MySQL database(s) and stored procedures # mysqldump –routines <dbname> Or you can backup only the stored procedures # mysqldump –no-create-db –no-create-info –no-data –routines <dbname>
The substr_count function in PHP counts the number of substring occurrences. This post describes how to create a mysql stored function to behave just like PHP’s substr_count function. This function can be created from your mysql console delimiter || DROP FUNCTION IF EXISTS substrCount|| CREATE FUNCTION substrCount(s VARCHAR(255), ss VARCHAR(255)) RETURNS TINYINT(3) UNSIGNED LANGUAGE SQL […]
This post is just a personal note on how to chmod files or directories recursively Recursive chmod only files within this folder find . -type f -exec chmod 0600 {} ; Recursive chmod only folders within this folder find . -type d -exec chmod 0755 {} ;