Category: MySQL

Paging in MySQL Command-Line Client

Paging in MySQL Command-Line Client

February 4, 2014 | By | Add a Comment

By default MySQL command-line client wraps lines in a SELECT query result and has no paging. You can solve both these problems by using the less command available in Unix/Linux systems.

Continue Reading

Importing and Exporting MySQL Databases

Importing and Exporting MySQL Databases

June 19, 2013 | By | 2 Comments

Importing and exporting MySQL databases in a Unix/Linux environment can be done easily with a single command. You can even choose to export the database’s structure or data only.

Continue Reading

Navigating MySQL Databases and Tables

Navigating MySQL Databases and Tables

June 18, 2013 | By | Add a Comment

Here is a list of MySQL’s command line client commands to navigate through the databases and their tables.

Continue Reading

Managing Application Settings in PHP

Managing Application Settings in PHP

March 27, 2012 | By | 2 Comments

There are multiple ways to save application settings/configurations in PHP. You can save them in INI, XML or PHP files as well as a database table. I prefer a combination of the latter two;

Continue Reading

Backup MySQL Databases to Amazon S3 Using PHP

Backup MySQL Databases to Amazon S3 Using PHP

May 16, 2011 | By | Add a Comment

With a few lines of PHP code and S3tool’s s3cmd command-line tool you can backup your MySQL databases automatically to Amazon’s S3. To use this script you’ll need SSH access to your server.

Continue Reading