MariaDB - Import | StackRender Docs

Learn how to import existing MariaDB database schemas into StackRender using tools like mariadb-dump and HeidiSQL. Convert your SQL schema into a visual ERD diagram in seconds.

You can import an existing MariaDB database schema into StackRender using the mariadb-dump utility.

Install mariadb-dump

Make sure mariadb-dump is installed on your machine.
It is included with most MariaDB installations.

Export the Database Schema

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

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

Example:

mariadb-dump -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 MariaDB database schema using HeidiSQL and import it into StackRender.

Open HeidiSQL

Launch HeidiSQL and connect to your MariaDB server.

Open the Export Tool

In the left sidebar, right-click the database you want to export and select Export database as SQL.

Export the Database Structure

In the export options:

Select No data to export the schema without table rows.
Make sure Create is checked to include the table structure.

Import into StackRender

Click Export to generate the .sql 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.

MariaDB is highly compatible with MySQL. This means that MySQL schema export methods also work for MariaDB.

You can also use tools like mysqldump or MySQL Workbench to export your database schema and import it into StackRender.