Load Delimited Data into MySQL

How to load Data from a CSV or any delimited file to MySQL:

LOAD DATA LOCAL INFILE ‘/path/to/file/name’ INTO TABLE `tablename` FIELDS TERMINATED BY ‘,’ LINES TERMINATED BY ‘\n’;

Keeping in mind that the delimited used here is , so FIELDS TEMINATED BY ‘,’

You can change the delimiter to any thing your data have.

BOLT — The Wonderful Blackberry Browser

BOLT is a web browser designed for Mobile Phones. It aims towards:

• Full PC-style browsing on all types of mobile phones
• Web content is never reformatted, repurposed or removed

I have tried it, its really nice, fast and it doesn’t drain the battery.. As advertised! Well Done!
Link: Bolt Browser

Bypass online censorship

In my country (Bahrain), many of my friends asks me on how to bypass firewalls, especially those days, where our ISPs started blocking almost everything!
My answer is very simple, whether use TOR or Ultrasurf.

Introduction About TOR: [Quoted from TOR Website]
Tor is free software and an open network that helps you defend against a form of network surveillance that threatens personal freedom and privacy, confidential business activities and relationships, and state security known as traffic analysis.

Tor protects you by bouncing your communications around a distributed network of relays run by volunteers all around the world: it prevents somebody watching your Internet connection from learning what sites you visit, and it prevents the sites you visit from learning your physical location. Tor works with many of your existing applications, including web browsers, instant messaging clients, remote login, and other applications based on the TCP protocol.

Introduction About Ultrasurf:
Since not much information about Ultrasurf is available, I have done some reverse engineering and I have applied my network engineering skills to get some information.
Ultrasurf uses port 443, They are using a protocol that is very similar to SSL, although, its not SSL, since I was not able to get any certificate from sniffing the traffic. They use Herricane Electric servers to get you to the internet.
Personally, I think that Ultrasurf is a masterpiece. One of the best softwares ever that gives the internet a freedom. Since it doesn’t only gives you freedom on the internet, but also in your working environment, and it passes almost every proxy setting I have tried it on.

Choosing a Linux Distro — Mandriva is a good choice

I formated my laptop after experimenting with Mac OSX, I wanted a good distro to be used on my laptop. Keeping in mind that I have a very good experience with Unix like systems, Especially Linux and FreeBSD.
On my desktop, I have been dual booting Slackware Linux and FreeBSD. I used to use Fedora on my laptop before experimenting with Mac.
Since I experiment a lot with my laptop, I wanted a distro that got everything on its DVD, like Slackware or Fedora. For Slackware, I will require to do lots of Customizations which I don’t have time for on my laptop. Fedora is perfect, however, I hate those almost daily updates which are huge in size. Few Months ago, I have tried Mandriva, and I really liked it, however, I had to do some experiments and I formatted on my older laptop. Today, I have installed Mandriva.

The Installation:

It’s really nice, very fast and responsive.. It gave me the option to copy the DVD to the hard drive, it really improves the install time!

Updates:
After a full install, the whole update for my all packages was only about 530MB to download! Unlike Fedora that required 1.2GB of downloads!!

Overall:
Mandriva is a very good Distro, everything comes on the DVD. Giving the option to have a full running system to do your job even without internet connection. Unlike Ubuntu!

Mac OSX Leopard — Review

I have been playing around with Mac OS X on my laptop and my desktop for the past two days. Mac OS X is a really cool operating system. But, on Mac Devices!
I have tried to get it working perfectly on my laptop but I couldn’t, thats due to ACPI incompatibility and Graphics card. However, its working perfectly on my Desktop PC. I really like the way you download apps and run them or even uninstall them! I wish if Linux and FreeBSD had this type of Software installation!

Post Using Mac OSX Leopard on HP Pavilion DV5-1235ee

This is a post using MacOSX on my laptop… Now, sound works, USB works, however reboots sometimes doesn’t work! ATI driver doesn’t work, and WiFi Driver doesn’t work!! Will write a post once I am done.
Update:WiFi works now.. Using a hack!!

Mac OSX — On HP Pavilion dv5-1235ee

I have been using Linux and FreeBSD for really long time on my desktops and servers, however, I have never used Mac OS X as my desktop. So, last night, I initiated the project of installing Mac OSX Leopard on my HP Laptop.
Last night, I tried installing iDeneb v1.4 image on my laptop.
First, The CD booted successfully, and it installed successfully, but I couldn’t boot the laptop after the install. It just kept on restarting. (Hmm, I don’t read manuals or instructions, so I missed that I have to use the Voodoo Kernel or use the AMD Patch).
However, after few installs, I got it booting, however, I never got to the GUI. After searching and reading here and there, I found out that the ATI driver was causing this issue. So, I reinstalled with a bit of a clean install, not much patches, only AMD patches stuff.
And I was happy to have Mac OSX booting on my laptop.

Summary of the install:

• Voodoo Kernel
• Seat-belt patch for DMG Images causing AMD to crash

Hardware Status:

• USB Works
• Web Cam Works
• ATI Video Card: Doesn’t work
• Sound Card: Doesn’t work, I need to install the driver
• WiFi: Doesn’t work, I need to install the driver
• Ethernet: works!!

PHP Framework — CodeIgniter

Few days ago, I was searching for a PHP framework that I can use for my web development. I found many Frameworks available, so I have set my search criteria to:
1. Ease of Use
2. Object Oriented
3. Good Community base
4. Flexible License, Preferably BSD — For Development of Commercial Apps.

I have came up with few, and one of them was CodeIgniter.
Such a wonderful Framework to work with.

No More Python — Back to Java

Well, I tried to use Python instead of Java… But I couldn’t succeed. Although, I am a very fast learner, but Python syntax and usability didn’t make sense to me. I am back to Java programming.