On my work PC I have several important files and folders that I would regularly want to backup. These are usually some MySQL database backend for a website, the website content itself, my Outlook .pst file and a folder containing important work documents. I wanted a backup script that would automatically backup these files regularly, … Continue reading Backup Scripts
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
David Vassallo's Blog 
You must be logged in to post a comment.