Sample Header Ad - 728x90

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