I run a number of web servers with PHP and MySQL and have a PHP command line script that runs on a daily basis to back up MySQL databases using the mysqldump command. It would be possible to do this using a simple bash script as well, and I know I used to use a bash script in the past but for some reason switched it to PHP at some stage.
mysqldump is a command line tool for outputting table structures and data and can be used for backups etc. By default mysqldump will dump all data from a table, but it is possible to select which data to be exported with mysqldump. This post looks at how to do this.
This article details how to save man pages as human readable plain text files. Man page is an abbreviation for Unix and Linux manual pages which form the basis of the help system for command line utilies.
The MySQL command line client allows you to quickly and easily run sql queries from a console session, as well as load sql script files etc. Once you have started up the MySQL command line client it is possible to execute shell commands from within the console and even drop out to another bash (or similar) session. This post looks at how to do this.
MD5 is a one-way hash algorithm which can be used for security or to verify the integrity of a file as it creates a digital signature for a file.
This article looks at how to use the sg_scan and sg_map utilities to scan the SCSI and USB bus to determine the device name and number for mounting USB devices on Linux.