HeidiSQL, how to export user definition
0
votes
0
answers
1018
views
I am using MariaDB version 10.5.9.0 on Windows version 10.0.19041.928 with HeidiSQL version 11.0.0.5919
I have exported the database structure which includes the tables, stored procedures and data. I also want to export the user I created to access the database.
In HeidiSQL I select the **Tools** top line menu option, then **Export database as SQL**, I check the database I want to export in this case called **training**, in the **SQL export** tab I check the **Drop** checkboxes for **Database(s)** and **Table(s)**, the **Data:** drop down is set to **Insert**, **Output:** is **Single.sql file**, **Filename:** is supplied the location and name to export to.
From the **mysql** schema I check the **user** table, then I click the **Export** button.
The SQL file created contains the structure of the user table but no inserts present where as the training database contains all the inserts and the stored procedures. Is there a reason why the user inserts are missing?
I want to use the SQL file as a complete set-up.
Asked by SPlatten
(149 rep)
May 5, 2021, 09:51 AM
Last activity: May 21, 2021, 08:08 PM
Last activity: May 21, 2021, 08:08 PM