The MySQL Control Center is a cross platform GUI for running queries on a MySQL database server. This article shows how to get mysqlcc to return more than the default 1000 rows by editing the server registration preferences or using the MySQL LIMIT syntax
If you have created an ISO image with a utility like mkisofs or have downloaded an ISO image from a website or FTP archive you can mount it on your filesystem without having to burn it to CD or DVD first. Doing this in Linux is fairly straight forward but it’s a two step process in FreeBSD.
Please note that these instructions are no longer valid for recent releases of FreeBSD because vnconfig is no longer supported. Thanks to Leif Neland for letting me know about this.
Thanks to Rollin Kibbe for supplying updated information available here.
Say for example you are wanting to mount a CD ISO image of a Linux distribution such as Fedora Core 3 Disc 1; the filename of the ISO file in this example is FC3-i386-disc1.iso This example assumes you are in the same directory as the ISO image and that the mount point (/cdrom in this example) already exists.
vnconfig /dev/vn0c ./FC3-i386-disc1.iso
mount -t cd9660 /dev/vn0c /cdrom
The above mounts the CD-ROM filesystem at /cdrom and doing ls -l /cdrom will show the contents of the root level of the CD.
umount /cdrom
vnconfig -u /dev/vn0c
It is likely you will need to be the root user to issue these commands. You can either do this by su‘ing to root or by using the sudo command like so:
sudo -u root vnconfig /dev/vn0c ./FC3-i386-disc1.iso
sudo -u root mount -t cd9660 /dev/vn0c /cdrom
sudo -u root umount /cdrom
sudo -u root vnconfig -u /dev/vn0c
The MySQL Command Line client allows you to run sql queries from the a command line interface. This post looks at how to show the tables in a particular database and describe their structure. This is the continuation of a series about the MySQL Command Line client. Previous posts include Using the MySQL command line tool and Running queries from the MySQL Command Line.
So Apple have announced the iPhone 6 and 6 Plus, featuring bigger phones than before. As a web developer creating responsive websites, does the size matter?
While it might be an issue for app developers, it shouldn’t be if you’re a web developer, because there already a bazillion screen resolutions and you should be designing for breakpoints, not resolution.
I liked this Tweet, which I think sums it up perfectly:
Dear responsive web devs: • iPhone 6: 375 × 667 px • iPhone 6 Plus: 414 × 738 px • If you care about this, you’re probably doing it wrong.
— Adrian Roselli (@aardrian) September 10, 2014
Here’s a couple of good articles on the subject:
Defining Breakpoints (“Breakpoints are the point a which your sites content will respond to provide the user with the best possible layout to consume the information.”)
Logical Breakpoints For Your Responsive Design (“There are several tactics for deciding where to put breakpoints in a responsive design. There is the rusty idea that they should be based on common screen sizes, but this doesn’t scale well. There are no “common” screen sizes. Another popular tactic is to create a breakpoint wherever the layout breaks.”)
I added this on September 13th 2014: What iPhone 6 screen size means for developers was posted on Clean Crisp Code.
phpMyAdmin by default opens a popup window when you click the "Edit" link underneath a query. I personally prefer to not have a popup window open and this post looks at how to change the default behaviour.
One of my Linux CD Mall customers emailed me the other day with a Linux annoyance: "The computer always booted into Linux by default if I wasn’t quick enough to stop it. Most annoying. I would have preferred the computer to wait until I told it where to boot but could not find a way of doing that. All of the Linux distros that I tried just take over without being asked." This post looks at how you can change the grub boot loader’s settings to solve this issue using a text editor. And I agree with him, it is annoying how the boot loader is often set up by default to boot into Linux too quickly.