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
A useful script to automatically resize an iframe (height and width) to fit contents in. No scrollbars ever again!! Continue Reading
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
Tags: AUTO_INCREMENT, INFORMATION_SCHEMA, MySQL
Have you ever wondered if your tables in a MySQL database may be nearing capacity on INT AUTO_INCREMENT columns? Continue Reading
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
If your OS does not support “ssh-copy-id” command, you can use the following instead. Continue Reading
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
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
Tags: CentOS, linux, logical volume management, LVM
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
For the purpose of this article, assume that /dev/sdb is the new disk that is to be installed.
Continue Reading
Tags: CentOS, linux, X Window System
Login as root or run all of the following commands using “sudo” Continue Reading
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