MySQL - Import | StackRender Docs

Learn how to import existing MySQL database schemas into StackRender using tools like mysqldump and MySQL Workbench. Convert your SQL schema into a visual ERD diagram in seconds.

You can import an existing MySQL database schema into StackRender using the mysqldump utility.

Install mysqldump

Make sure mysqldump is installed on your machine.
It is included with most MySQL or MariaDB installations.

Export the Database Schema

Run the following command in your terminal to export only the database schema (without data):

mysqldump -u [username] -p --no-data [database_name] > [output_file.sql]

Example:

mysqldump -u root -p --no-data example_db > example_db.sql

This command will prompt you for your database password and generate a .sql file containing your database schema.

Import into StackRender

Open the generated .sql file, copy its contents, and paste them into the Import SQL section in StackRender.
Then click Import to generate the diagram.

You can export a MySQL database schema using MySQL Workbench and import it into StackRender.

Open MySQL Workbench

Launch MySQL Workbench and connect to your MySQL server.

Open the Data Export Tool

In the top menu, navigate to:

Server → Data Export

Export the Database Structure

In the Export Options section:

Select Dump Structure Only to export the schema without data.
Choose the database you want to export from the list.

Save the SQL File

Enable Export to Self-Contained File, then choose a location and provide a name for the .sql file.

Import into StackRender

Click Start Export to generate the file.

Open the generated .sql file, copy its contents, and paste them into the Import SQL section in StackRender.
Then click Import to generate the diagram.