CODEWITHSUNDEEP
databasedatabase-designmysql-workbench
Bora Bogdan
Bora Bogdan

Reputation: 67

Exporting database from MySql Workbench

I have made a database in MySql Workbench. Along the design, I deleted a couple of tables since they weren't necessary. But, when I try to export the database to phpmyadmin, all of those tables appear in the code. How do I solve this?

Upvotes: 0

Views: 326

Answers (1)

Muhammad Rizwan Kaim Khani
Muhammad Rizwan Kaim Khani

Reputation: 2080

In MySQL Workbench 6.0 CE.

I think it is very easy.

Suppose first you add a table in the database. for doing that.

  1. Click on Database Menu. and then click on "Next to Database".
  2. You all database will show on left side.
  3. Click on db and then right click on table. Create New Table.
  4. Now you will create a new table. Click on Apply and you watch table is created.

Now You need to drop this table.

Just right click on a table. and click on drop table. and a dialog box will open. Choose drop and the your created table will be deleted.

Now if you export your db, this deleted table will not show up.

If you had made relationships among different tables then the table will not be deleted until you remove that relationship.

Thanks.

Upvotes: 1

Related Questions