Related Articles
Password less command line scripts with MySQL 5.6
I have a number of command line scripts that copy MySQL databases down from staging servers and store them locally. These scripts set the password on the command line using the -p option. With MySQL 5.6, a new warning is displayed every time my scripts run: Warning: Using a password on the command line interface […]
Useful MySQL Commands
Database with size SELECT table_schema “DB Name”, Round(Sum(data_length + index_length) / 1024 / 1024, 1) “DB Size in MB” FROM information_schema.tables GROUP BY table_schema; Create a database. mysql> create database [databasename]; List all databases on the server. mysql> show databases; Switch to a database. mysql> use [db name]; To see all the tables in the […]
Installing the Free G729 Codec for Asterisk
This tutorial will let you install the G729 Codec on an Asterisk installation in under 5 minutes. Navigate to the codecs directory: cd /usr/lib/asterisk/modules Download the codec Codecs are provided as binary .so files, you can find the archive at http://asterisk.hosting.lv/#bin Take care of the following when picking up one of the files, they depend […]