Build a database directly from the MySQL command line

Because the colleague requests, when carries on the mysqldump the import library, adds a date label,

The premise of But,mysqldump is that the database name should exist in the database.

The command is then executed with the-e parameter.

This reminds me of a colleague I consulted shortly before, if awk passes variables, what parameters do they use? -V

:)

Now_time= 'date'+%g%m%d%h%m%s"gzip -d/back/"  CREATE database xxx_$now_time"-uxxx-pxxx xxx_$now_time </back/xxx.sql

Build a database directly from the MySQL command line