Increase Virtual Box VDI disk size on MAC or Windows

Need more space on your Virtual Box disc? I installed Windows 7 on Oracle Virtual Box but didn’t estimate the size of disk correctly. The drive is now nearing it’s capacity, how do you extend the size?  Continue Reading

Cross browser iframe auto-resize script

A useful script to automatically resize an iframe (height and width) to fit contents in. No scrollbars ever again!! Continue Reading

Inject empty transactions in MySQL 5.6 GTID based Replication

As you probably already know, SET GLOBAL SQL_SLAVE_SKIP_COUNTER = n doesn’t work anymore if you GTID based replication. Is there a way to skip a single transaction in such a case? Continue Reading

MySQL auto_increment capacity calculation

Have you ever wondered if your tables in a MySQL database may be nearing capacity on INT AUTO_INCREMENT columns? Continue Reading

Prestashop direct wget download

For those who have ssh access to their Web server and would like to download Prestashop directly rather than first downloading it locally and uploading/FTP’ing to the server, here is the direct download link: Continue Reading

MAC ssh-copy-id (password less ssh login)

If your OS does not support “ssh-copy-id” command, you can use the following instead. Continue Reading

How to prepare SD Card for Raspberry Pi on a MAC

If you didn’t buy the pre-populated SD card to boot up your Pi, you need to prepare one yourself. Relax, it’s easy… Continue Reading

How to resize / extend primary partition in Windows / Server

Most of the times, it’s the C drive on a Windows machine that needs to be extended to create more space than was allocated during initial install. Continue Reading

CentOS Logical Volume Management

An alternative to creating fixed partitions and file systems is to use Logical Volume Management (LVM) to create logical disks made of space from one or more physical disks or partitions. Continue Reading

Adding a new disk to CentOS

For the purpose of this article, assume that /dev/sdb is the new disk that is to be installed.
Continue Reading

How to install GNOME X Window System on CentOS Linux

Login as root or run all of the following commands using “sudo” Continue Reading

mysqldump: What to do with long line lengths

When creating database dumps using mysqldump, by default, every table corresponds to one row in the dump file. As you can image this row can be huge if there are lots of rows in the table.

The reason mysqldump does this is that such dumps are more efficient when restoring data. This is essentially because the “batch” inserts are much faster than if it generated a separate INSERT query for every record in every table. In addition, the size of the dump file also quite a bit smaller.

If you would like to have smaller lines – one per row as against … Continue Reading