The following lines were added (+) and removed (-):
=== mysqldump backup ===The most common use of mysqldump is probably for making a backup of whole databases. mysqldump --all-databases --lock-tables -p > all_databases.sqlThis will back up all databases and prevent access during the backup process. The --lock-tables is what prevents the database from being modified during the backup. The -p switch will prompt you for your mysql password before commencing. The > is to output to the file name of your choice ending in the .sql extension, for creation of a text readable file.If you wish to backup a specific table mysqldump --opt payrolldb --lock-tables -p > payrolldb_backup.sqlIn this example=== mysql restore ===