How to Start, Stop and Restart MySQL

What do you do if your database server is down? Well, you can certainly reboot the server. That might solve the problem, but I rather restart the database first before doing something as drastic as rebooting a server. There are instances were rebooting doesn’t always solve the problem if there’s an issue with the database. Now, most open-source blogs and web applications today use MySQL as their database of choice. So, here are instructions on how to start, stop and restart MySQL on Ubuntu and Debian-based systems.

Stop MySQL database

$ sudo /etc/init.d/mysql stop

Start MySQL database

$ sudo /etc/init.d/mysql start

Restart MySQL database

$ sudo /etc/init.d/mysql restart

Ubuntu Releases

Canonical, the company behind Ubuntu is once again contemplating whether to go with interim releases or go with rolling releases. The company has entertained this idea at least once before ultimately settling with the old release schedule. Now, there are talks again of doing away the old schedule or going with a rolling release.

Why can’t Ubuntu do both releases. Canonical should do LTS (Long Term Support) for companies and individuals who clearly have a need for long term support, while most individuals like myself would rather have a rolling release to keep with latest developments, as well as avoid big haul upgrades every six months. That would be the ideal situation.

Tips For Skype Interviews

Chances are you may have already experienced a Skype interview. Recently, more and more companies are performing interviews online as they recruit more talent globally. Even if you are a local candidate, chances are you may end up with a Skype interview. Six out ten HR managers now conduct online interviews in the US. Online interviews are cost effective, and they save time for both company and potential employee. So, here’s a nice article from BBC offering some valuable tips when interviewed on Skype.

Resize Disk Images At Linode

Virtual private servers or VPS such as Linode, where this site is hosted, allow users the ability to resize their disk images. Resizing allows you to allocate more storage to a disk image so you can store more files, or shrink a disk image so you have more storage for the other disk images in your account.

Here’s a quick checklist on how to resize a disk image in Linode.

  1. Log in to the Linode Manager.
  2. Click the Linodes tab. A list of your virtual private servers appears.
  3. Select a Linode. The Linode’s dashboard appears.
  4. Click Shut down to turn your Linode off.
  5. Select the disk image you want to resize. The Edit Disk Image webpage appears.
  6. In the New Size field, enter a different size for the disk image in megabytes.
  7. Click Save Changes. The Linode’s dashboard appears.
  8. Click Boot to turn on the Linode.
  9. You have successfully resized the disk image.

What Happens To GoDaddy Expired Domains

If you have a registered domain that is expiring at GoDaddy, to their credit, they do send out several notices to let you know that your domain is expiring. But the day after your domain expires, your domain is no longer working and it gets parked at GoDaddy. Although you make a payment on the same day. It can take anywhere from 2-24 or even 48 hours for the domain to propagate the DNS entry.

So, in the meantime, your website is screwed. Your customers will see a parked page at GoDaddy. If your website is a critical business website, you can potentially lose money. The delay is more of a DNS issue instead of GoDaddy. Even at this age in time, you would think DNS propagation delay can be resolved in minutes instead of days. Unfortunately, we are still stuck in the horse-and-buggy age when it comes DNS management.

But GoDaddy has to do better in protecting business when it comes to downing websites. Although it’s entirely my fault to not properly pay on time, GoDaddy doesn’t give you much grace time when it comes to missing a payment. Although it their right to do this, I don’t think they are winning any customers. I have other domains registered at other registrars. I missed payments by a couple days, but they give you ample of time of at least a week before redirecting your DNS entry. So, your website is never down.

So with that, GoDaddy policies are not winning me over. I will transfer any remaining domains I own out of GoDaddy as soon as I can.

iPad Mini Due In March 2013

So soon. For those of you holding off to purchase the first generation of the iPad mini, you may not have to wait too long. Rumor on the street says that a second generation of the iPad mini with Retina display is due in March of this year. That’s one quick turnaround.

A friend of mine who is a bit older, said that he couldn’t really tell a difference between an iPad mini without a Retina display, and the original iPad equipped with a Retina display. I think he is saying the screen on the iPad mini is not as bad. I think the screen size of the iPad mini and the screen resolution somewhat makes it quite acceptable.

But, the upcoming Retina display on the iPad mini will really make the screen much clearer. Most people would be able to tell a difference. Some apps will really take advantage of the Retina display and make the iPad mini shine. So, I can’t wait for this second generation of the iPad mini to get here. And March is just around the corner.

How To Make TinyMCE fonts bigger

The following instructions will show you how to make the fonts on your TinyMCE editor a little bigger than the default 10px. If your eyes are not as good mine, then you may need to increase the fonts to something a little bit more legible. Font sizes bigger than 12px would do.

If you are not familiar with TinyMCE, it’s a popular web-based text editor used by many web applications, CMS and blogging software. WordPress uses TinyMCE editor as well, which is the blogging software for this blog. Now, if you need to increase the size of the text in the textarea, then you will need to edit the several themes that came with TinyMCE.

I ended up editing several themes anyway because I didn’t clear the cache at first, and I kept trying different themes without seeing any changes. You will need to clear the cache in your browser to really see the desired results.

There are a total of 4 different themes in the TinyMCE folder. They are located at: tiny_mce/themes/advanced or tiny_mce/themes/simple folders. Change the font size for the textarea of the theme you are using. I found the CSS at the top of each file.

Clear your cache and reboot. You should see a much bigger font size of 12px.

Converting To AT&T Uverse

A few weeks back, AT&T notified me that they are converting the entire neighborhood from DSL to Uverse. To make the switch, they are sending out a free modem. They told me the download speed is going to be the same, which is 6MB, which is not fast by any means, but it serves my purpose. I could always a higher speed, but it will cost more. The upload speed is 1MB, which is about 3 times faster than the 300kb than I have now. As part of the promotional, they will only charge me $20 per month for 1 year. After that, it goes back to the usual $43 per month. It think it’s a great deal.

Twenty Twelve Theme

I recently changed themes from a custom made one, that I’ve used for a long time, to a theme called Twenty Twelve, the current WordPress default theme. I made one slight change though which alters the entire look of the theme. I changed font from the default ‘Open Sans’ to ‘Lato’ which is available from Google. To facilitate the change, I’m using my Webfonts plugin and this CSS code:

#page {font-family:'Lato', sans-serif;}