Databases

Fixing mysqldump unknown table COLUMN_STATISTICS

I am by no means a database guy. I am barely even a server guy. But, recently, I was tasked with exporting a sizeable database from Amazon RDS for use with local development servers. After running the following mysqldump command: mysqldump --host hostname -u username -p dbname > dbdump.sql I am asked for the database password and then proceed to get an error complaining about an unknown table called COLUMN_STATISTICS. Unknown indeed, I had no idea what this table was even for or why mysqldump was trying to query it.

Navicat Premium vs Sequel Pro For Mac OSX

Deciding between whether or not to buy Navicat Premium for Mac at a cost of $70 or using Sequel Pro which is free, was a difficult decision believe it or not. I use Navicat on my Windows PC, but have been using Sequel Pro on my MacBook Pro. Paid vs free: should be an easy decision to make, right? Well, not exactly. Navicat Premium allows you to work with most database types: Microsoft SQL Server, MySQL, PostgreSQL, SQLite and even Oracle. Sequel Pro from my understanding is really only for MySQL at this point in time, but other databases are planned I think.