Import a database via command line

cd into the directory of the new database.

mysql -uroot -proot [existing-database] < [new-database].sql

Specifically ask for MAMP PRO mysql

MAMP/MAMP Pro is an application that runs a MySQL, Apache and PHP stack on Mac.

/Applications/MAMP/Library/bin/mysql --host=localhost -uroot -proot

Get size of all databases

SELECT table_schema AS "Database name", SUM(data_length + index_length) / 1024 / 1024 AS "Size (MB)" FROM information_schema.TABLES GROUP BY table_schema;

Kickstarter Coming January

I'm launching a board game called Delivery Duck. You're a duck, in a truck, delivering packages. It's a strategic family game for 2 to 6 players.

Check out the board game!