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