Nugget post (useful nuggets of information pertaining to MySQL) - Ubuntu mysql configuration (including username and password) is stored in: /etc/mysql/debian.cnf - Import data from csv file: LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3); - Database manipulation: show databases create database [dbname] drop … Continue reading Useful MySQL commands
The SheevaPlug Experience
In one of my first posts I referred to the fact that I am running this wordpress blog on a SheevaPlug (more details about this server here). Below is a rather lengthy post with my notes about setting up this server The Sheeva Plug Experience 0. Connected USB from Sheeva to PC. PC found new … Continue reading The SheevaPlug Experience
David Vassallo's Blog 