I wanted to send out a newsletter to all of my clients. So I can use WHM/cPanel or THT(billing system) to send them out. But it is possible that the emails would not reach it’s destinations. Or it is possible that I end this up with blacklisting my server’s IP address.

So I needed another solution and came up with sending the emails through MailChimp – A professional EMail marketing service. So they will handle everything and I will have a complete report of the EMails I send out.
But the thing is, I didn’t had all the email addresses of my clients anywhere except for the database of my billing system. And when I try to export the MySQL database to a local file and import emails through it ended up failure. Because there are more fields in the MySQL table rather than emails itself.

There is a possible way to extract only the emails from a MySQL database. That is to use phpMyAdmin to execute a custom query to display only emails and export the view.
This is how you can do that.

1. Login to phpMyAdmin
2. Select the database and choose the table which contains the email addresses. Click on the Browse button.
3. Click on SQL and execute the following command.
   SELECT 'email' FROM `your_table`
   email should be replaced with the name of the field which contains email addresses while your_table should be replaced with the table name which contains email addresses and other information.
   Usually, it is already set. So you won’t need to change a thing except for email.
4. Click on Go and phpMyAdmin will show a view that contains only the email addresses.
   
5. Click on the link Export at the bottom of the page. Not the Export in the Tab bar.
6. Export it as your desire. Personally, I like to have an .CSV file.

From this method followed, you will have a CSV file which contains all the email addresses from your users.
It is possible to use the same method to extract email addresses from your forum, wordpress blog or any other MySQL database which contains email addresses. Just be sure you won’t use them to spam your users.

Have you ever tried to change nameservers of your website? What happens then?
Your domain registrar changes them into your new nameservers and then they update their records of your nameservers. And let those new nameservers to be public. And when your ISP(Internet Service Provider) accesses the registrar’s database, they find the modification to your nameservers and update their records as well. So then you can access your website which is on different nameservers now.

This looks like a 1-2-3 process. But it is not.

This whole procedure takes lot more time. Most likely, it is about 24-48 hours. This is because ISP’s don’t update their records very frequently. So even if it takes 5 minutes for you to change your nameservers, it takes 24-48 hours to see your website in your new server.
This is where we need Google Public DNS.
» Read more: Google Public DNS – Use and Boost your DNS Caching Speed

United States(US) is the place where the largest datacenters exist in the world. Not only large, they have very large number of datacenters situated in the US(mainly in North America) and also has good connectivity providers like Level3, Cogent and HE(Hurricane Electric).

It is said that HE maintains a good connectivity to Asia. And I believe it is true. But my suggestion is to avoid hosting your websites in US if your main audience is from Asia. Why is that?
I would post you some ping results rather than explaining it first.
» Read more: Asians, why it is not good experience to host your website in US?