Category: MySQL

View Sizes of MySQL Databases & Tables over SSH 0

View Sizes of MySQL Databases & Tables over SSH

Sometimes, your typical database GUI (such as phpMyAdmin) won’t be usable for managing really big databases and you’ll have to work directly on the command line (SSH) for this. After connecting to your server,...

MySQL 0

Importing & Exporting MySQL Databases on the Command Line (SSH)

Quite often, it can prove problematic dealing with large MySQL databases in a web interface such as phpMyAdmin. Working directly on the command line is far quicker and less painful if you’re having to import/export large databases.

The below commands only scrape the surface of managing databases directly on the command line but cover import/export.