MySQL
Calculating MySQL Database sizes in Linux
Posted on Thursday 5th of May 2011 by Eric Potvin
How to create a script that calculates folders and MySQL database sizes
Count the number of occurrences of a char in MySQL
Posted on Sunday 10th of April 2011 by Eric Potvin
Simple SQL script to know the number of occurrences in MySQL
How to Move MySQL Database Data Directory
Posted on Wednesday 27th of July 2011 by Eric Potvin
Step by Step guide to move a MySQL data directory to another folder
Joining MySQL tables
Posted on Wednesday 7th of December 2011 by Eric Potvin
What is a LEFT JOIN, INNER JOIN, CROSS JOIN and STRAIGHT_JOIN?
MySQL Field Types
Posted on Thursday 7th of April 2011 by Eric Potvin
List of MySQL column types and their characteristics
MySQL load data infile error 1148
Posted on Saturday 18th of May 2013 by Eric Potvin
How to import dta from a CSV file in MySQL without the ERROR 1148
Replace MySQL with MariaDB
Posted on Sunday 30th of June 2013 by Eric Potvin
Quick guide to replace MySQL and install MariaDB on linux
Save Last MySQL Command
Posted on Sunday 6th of May 2012 by Eric Potvin
How to save, and not overwrite, last executed MySQL command in VIM
Secure your Website from SQL Injections
Posted on Thursday 1st of March 2012 by Eric Potvin
Learn how to sanitize and prevent SQL injections using PHP
Select a portion from a MySQL Blob Field
Posted on Friday 16th of March 2012 by Eric Potvin
Select a part of a blob or text field instead of the full text
Simple automated MySQL Backup databases script
Posted on Sunday 28th of August 2011 by Eric Potvin
How to use the cronjob to backup MySQL databases and tables automatically
Using mysqldump with subqueries
Posted on Monday 12th of November 2012 by Eric Potvin
How to export and import data from a mysqldump using a subquery with MySQL