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

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.