MySQL

Calculating MySQL Database sizes in Linux

Posted on Thursday May 05, 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 April 10, 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 July 27, 2011 / by Eric Potvin

Step by Step guide to move a MySQL data directory to another folder

Joining MySQL tables

Posted on Wednesday December 07, 2011 / by Eric Potvin

What is a LEFT JOIN, INNER JOIN, CROSS JOIN and STRAIGHT_JOIN?

MySQL Field Types

Posted on Thursday April 07, 2011 / by Eric Potvin

List of MySQL column types and their characteristics

MySQL load data infile error 1148

Posted on Saturday May 18, 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 June 30, 2013 / by Eric Potvin

Quick guide to replace MySQL and install MariaDB on linux

Save Last MySQL Command

Posted on Sunday May 06, 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 March 01, 2012 / by Eric Potvin

Learn how to sanitze and prevent SQL injections using PHP

Select a portion from a MySQL Blob Field

Posted on Friday March 16, 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 August 28, 2011 / by Eric Potvin

How to use the cronjob to backup MySQL databases and tables automaticly

Using mysqldump with subqueries

Posted on Monday November 12, 2012 / by Eric Potvin

How to export and import data from a mysqldump using a subquery with MySQL