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