Automatic mysql backup _ MySQL

Mysql automatic backup time = 'date + % G % I % d % H % M' # yyyy

Db = products
Echo "# product database">/sqlbak/$ {db }_$ time. SQL # The backup file name is [Database name_. SQL]
Mysqldump -- add-drop-table-c -- allow-keywords -- force -- password = 1234567890 -- user = root $ db>/sqlbak/$ {db} _ $ time. SQL

Db = news # Another database

Echo "# News Library">/sqlbak/$ {db} _ $ time. SQL
Mysqldump -- add-drop-table-c -- allow-keywords -- force -- password = 1234567890 -- user = root $ db | bzip2-9>/sqlbak/${db1__$time. SQL .bz2

# -- Add-drop-table is to add a delete command.
#-C is the complete insert. each row of insert includes the field name.
# -- Force
# -- Allow-keywords: backquotes are added to the field names when reserved words are used as field names.