If you need to import data from CSV or other text-based files to a MySQL database or vice-versa, you can use the LOAD DATA or SELECT INTO OUTFILE statements explained below.

Examples - Importing files with LOAD DATA

A MySQL LOAD DATA statement can be used to load values from any text-based files (such as comma separated, tab separated, etc.) into database tables.

In the examples below, a CSV file with the following content is imported:

"column1","column2","column3"
1,"foo",10
2,"bar",20
3,"baz",30

… into a table with the following structure:

CREATE TABLE `test_table` (
`column1` INT NOT NULL,
`column2` VARCHAR(100) NOT NULL,
`column3` INT NOT NULL,
PRIMARY KEY (`column1`)
);

A simple import:

Read the rest of this entry »

A video of Steve Wozniak discussing one of the chapters from his book, iWoz: Computer Geek to Cult Icon, How I Invented the Personal Computer, Co-Founded Apple, and Had Fun Doing It.

Steve Jobs opened today’s Apple Event at the Yerba Buena Center for the Arts Theater in San Francisco by stating, “We want to kick off 2010 by introducing a truly magical and revolutionary new product.”

Jobs explained that due to iPods, iPhones, and MacBooks, Apple is the largest mobile devices business in the world today, generating more revenue than Sony, Samsung or Nokia.

According to Steve, a new device aimed at the niche between laptops and smartphones would need to be able to perform certain functions (browsing the web, enjoying and sharing photos, videos and music, playing games, and reading e-books) better than either laptops or smartphones, and to me it looks like Apple’s new iPad will succeed where netbooks have failed.

Join the discussion of the Apple iPad in the Geekology Forums here.

Introductory Video

Keynote Video

Apple iPad Features

The iPad runs an operating system similar to the iPhone OS with a customizable homescreen and a full multi-touch interface on a 9.7-inch IPS capacitive glass screen. Like with the iPhone, a semi-translucent keyboard appears on-screen when needed, and web pages, photos, movies, books, calendars, emails, and other applications and games can be enjoyed in a landscape or portrait orientation.

The device comes with several applications built-in: Safari, Mail, iCal, Address Book, Google Maps, YouTube, Photos, Music, and more. All these applications have had a major user interface redesign to optimize them for a large multi-touch screen, and their data can be synchronized with your Mac or PC via a USB cable. If you’re using a Mac, the iPad will also pull Places and Faces for photos from iPhoto.

Read the rest of this entry »

cPanel in combination with WHM is a Unix-based (usually integrated with CentOS Linux) web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting websites.

In combination with WebHost Manager (WHM), the software offers GUI, command line, and API-based access that allows third-party software vendors, web hosting organizations, and developers to automate standard system administration processes to manage hosting accounts on a web server.

If you have a WHM-based server running behind a firewall, you’ll need to open certain ports on your firewall to enable all services. The following are lists of Inbound and Outbound Ports used by the cPanel and WHM software:

Read the rest of this entry »