Useful MySQL commands

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

OSPF route failover

A colleague recently asked why, at a basic level, is dynamic routing such as OSPF useful? The very first thing that comes to mind is of course route failover. That is, when a network contains multiple routes to the same network, dynamic routing automatically will "failover" to an alternative route when the primary route is unavailable. … Continue reading OSPF route failover