Paging in MySQL Command-Line Client

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. Entering the following command …

Importing and Exporting MySQL Databases

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. Exporting is done using the mysqldump …

Navigating MySQL Databases and Tables

Here is a list of MySQL's command line client commands to navigate through the databases and their tables. First run the client program by entering the following at the command line: The -u option is …

Managing Application Settings in PHP

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; saving …

Backup MySQL Databases to Amazon S3 Using PHP

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. First download …