Create database schema diagram from .sql file for mysql

开发者_如何学运维Is there any database schema generation tool that creates schema diagram by importing the mysql .sql database schema file.

I believe that MySQL Workbench is what you're looking for.

I haven't done it myself, but it does support importing of SQL files.

Also you can point your existing DB to Workbench and create a schema graphically and do what ever changes you prefer.

Then you can export a set of new changes to a different SQL so, you can easily upgrade your production databases.