Monthly archives: February 2012

How to get a server’s serial number from shell

There are sometimes when we need a box serial number — to open a support trouble ticket, for example — and for some reason we just don’t have it. If the box is in a remote datacenter this can be…

Posted in Sysadmin, Unix | Comments

Simple rotate log script

There are some situations where you have an automatic process that creates a log file. If the process is run on a periodic basis and you don’t add something like a timestamp to the log file name, the log ends…

Posted in Shell Scripts, Sysadmin, Unix | Comments

How to move all objects in a schema to a different tablespace

There are some situations where you need to move all objects in a schema to a tablespace different to where they are stored. I have faced this when restoring a database coming from a development environment into a production environment….

Posted in Databases | Comments

How to install MySQL in Solaris 10

I recently had to install a MySQL server into a Solaris 10 box. This is how I did it: 1.- INSTALL THE PACKAGE (I downloaded the package from bash-3.00# pkgadd –d mysql-5.1.48-solaris10-sparc-64bit.pkg 2.- CHANGE DATA DIRECTORY (THIS IS WHERE…

Posted in Databases | Comments

Swedish Greys - a WordPress theme from Nordic Themepark.