Search code examples
mysqlsqldatabasemysql-workbench

How to generate the whole database script in MySQL Workbench?

I want to take the whole database. Where do I find the database file?

And is there a way to write the whole database with all data to a text file (like the one in SQL Server)?

Solution

  • Q#1: I would guess that it's somewhere on your MySQL server? Q#2: Yes, this is possible. You have to establish a connection via Server Administration. There you can clone any table or the entire database.

    This tutorial might be useful.

    EDIT

    Since the provided link is no longer active, here's a SO answer outlining the process of creating a DB backup in Workbench.