Re: Database Deployment

[Mike Lischke]

Colin,

in short: there is no deployment concept in MySQL other than what you would define yourself. Deployment means here to copy a set of schemas from one server to another (and optionally carry over users + their access rights etc.).

Except for the users this is all what schema dump + restore (or migration) is about. A typical case is to dump the schemas you want to carry over to an sql script and load that on the target server. With MySQL Workbench you can do this with a comfortable GUI as separate steps or use migration to directly copy over your data (including meta data transfer).

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/