It may be useful to make a backup of a specific database through the command line. Surely it is easier to use tools like phpMyAdmin, but in case of emergency or because you prefer use the shell, this info is certainly useful. The executable that performs the operation is “mysqldump” which is usually installed with [...]

Pre-requisites:
Database host or IP
Database name
Username and password access of db.
First we need to declare some critical data like username and password, so i strongly recommended to store this value into a different file where php will ask tables and data, this for security reason.
In the php convension, usually we make a file called config.inc.php, because [...]