databases | Geekology

Importing or Exporting comma-separated (CSV) and other text-based files to / from MySQL databases

04 Feb 2010 0 Comments

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 in this post.

databases, mysql, tips & tricks

columns, export, fields, import, load data, privilege, select, select into

List of cPanel / WHM Inbound and Outbound Ports

27 Jan 2010 1 Comment

This post lists Inbound and Outbound Ports used by the cPanel and WHM software that should be opened if you’re running WHM behind a firewall.

api, centos, command line, control panel, firewall, gui, inbound, linux, outbound, ports, web hosting

Funny easter eggs built into Wolfram|Alpha

24 Jun 2009 9 Comments

Wolfram|Alpha is the computational knowledge engine developed by Dr. Stephen Wolfram; its developers added several easter eggs to the public release.

databases, humor, news

computation, easter egg, funny, knowledge, wolfram alpha, wolfram|alpha

Enabling remote access to a MySQL Database Server

16 Jun 2009 0 Comments

By default, remote access to the MySQL database service is disabled. If you need to enable remote access, you can follow these steps.

administration, configuration, host, my.cnf, permission, remote access, user account

Exporting your iPhone’s SMS Message Database to a CSV file

26 May 2009 22 Comments

SMS messages on the iPhone are stored in a SQLite database, and if you need to back up your messages you can do so using one of these methods.

backup, csv, cydia, database, export, iphone, jailbreak, openssh, scp, sms, sqlite, ssh

Configuring a Vodafone 3G modem on Ubuntu Linux 9.04 (Jaunty Jackalope)

24 May 2009 35 Comments

Vodafone 3G modems like the Huawei E220 USB 3G can be set up on most distributions of Linux using these instructions.

3g, 3g modem, debian, e220, huawei, jaunty jackalope, linux, modeswitch, python, sqlite, ubuntu, vmc, vodacom, vodafone, vodafone mobile connect

Displaying MySQL CLI query output vertically

11 Apr 2009 0 Comments

The MySQL CLI is a great tool to test queries, but output containing many columns usually breaks onto new lines, rendering the results unreadable.

databases, mysql, tips & tricks, tools

cli, command line, command line interface, connect, database, delimiter, horizontal, mysql, pager, prompt, query, query output, sql, vertical

Changing the default MySQL root (or other user) password

16 Feb 2009 0 Comments

In new MySQL installations, the default root password is set to ” (nothing), which poses a huge security risk on production servers.

databases, mysql, tips & tricks, unix

development, mysqld, password, privileges, production, root, security, terminal

Geekology

Importing or Exporting comma-separated (CSV) and other text-based files to / from MySQL databases

List of cPanel / WHM Inbound and Outbound Ports

Funny easter eggs built into Wolfram|Alpha

Enabling remote access to a MySQL Database Server

Exporting your iPhone’s SMS Message Database to a CSV file

Configuring a Vodafone 3G modem on Ubuntu Linux 9.04 (Jaunty Jackalope)

Displaying MySQL CLI query output vertically

Changing the default MySQL root (or other user) password

Vote for us in the SA Blog Awards!

facebook & rss

videos

categories

archives

blogs

coding

entertainment

podcasts

productivity

tech news