Topic: Doctrine with Symfony
Keyword: YAML, symfony, doctrine, generate, schema, mysql, workbench
Question: How to generate YAML files for Doctrine using MySQL Workbench?
Answer:
1.
Download and install MySQL Workbench
2.
Download and un-stuff the MySQL Workbench Doctrine Plug-in
3. Launch MySQL Workbench
4. Go to the TOOLS > INSTALL PLUGIN/MODULE FILE
5. Navigate to the DoctrineExport.grt.lua file
6. Go to DATABASE > REVERSE ENGINEER
7. Fill in the correct database information for your server
8. Choose your Database, and click through the rest of the dialogue
9. When it finishes, you should all your tables
10. Go to ARRANGE > AUTOLAYOUT (this isn’t really necessary, just makes it so you can see what’s going on)
11. Go to PLUGINS > CATALOG > DOCTRINE EXPORT 4.0 (either choose clipboard or file)
Source: http://technotes.steudel.org/2009/12/how-to-generate-yaml-files-for-doctrine-using-mysql-workbench/