Tagged: ssh

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,...

2

Upgrading PHP 5.3 to 5.4 on CentOs 6

We recently had to upgrade PHP from 5.3 to 5.4 on a CentOs 6.6 build (which by default is packaged with PHP 5.3) and found quite a number of differing tutorials and recommendations on the...

SSH Cheatsheet 0

SSH Cheatsheet

Server / Spec Checks Checking the server memory (RAM) consumption:-

Checking the server HDD consumption:-

Checking the size of each top-level directories from a directory:-

Checking the server date/time:-

Checking...

0

Reindex Magento Indexes via SSH

The default indexer in Magento can be quite a time consuming process sometimes, a real time-saver if you have SSH access to your server is to work directly on the command line using the...

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.