Is there a tool to create MySQL database model from an existing MySQL database?

I am looking for a piece of software to allow me easily create the database mode for an existing MySQL database

From stackoverflow $pageUsers[$entry.posts[0].author].name

• If you use mysqldump with the --no-data option, you can extract the schema from the old database. There can be issues with views using this method, see this article for a workaround.

  You can copy a schema in this way with something like this:

  mysqldump --opt --no-data olddatabase | mysql newdatabase
  

  From Paul Dixon

• You can dump the database schema to SQL using the mysqldump command.

  mysqldump {databasename} --no-data=true -u {username} -p  > database_schema.sql
  

  From Matt

• http://dev.mysql.com/workbench/ is still in Beta (depending on your Operating System), but can be a handy tool for exploring the schema of databases - there is a free version to.

  Use mysqldump on your DB as the other answers state then import the resulting file into this program.

  From James