The following lines were added (+) and removed (-):
Note: The mysqld service is running when you use mysqldump. mysqldump --opt payrolldb --lock-tables -p > payrolldb_backup.sql mysqldump --opt payroll --lock-tables -p > payroll_backup.sqlIn this exampleIn this example we pipe the backup into gnuzip to compress it for archival purposes. mysqldump --opt payroll --lock-tables -p | gzip > payroll_backup.sql.gz In this example the payroll table is being dumped to a backup file. It is possible to dump several databases with one command. mysqldump --databases payroll accounting --lock-tables -p > business_backup.sqlTo restore a single table to the database. mysql -p payroll < payroll_backup.sqlTo restore multiple tables to the database. mysql -p < business_backup.sql[[Category:SQL]]