# Database location in Ignition **URL:** \ **Category:** Ignition\ **Created:** [May 16, 2022, 6:39pm UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630 "2022-05-16T18:39:21Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![PRAMANJ](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pramanj/32/66935_2.png) [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Post date:** [May 16, 2022, 6:39pm UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/1 "2022-05-16T18:39:21Z")
I thought Ignition saves its data bases like users/roles/historian or whatever DB it creates, in default data folder of mySql data base. However it doesn't seem to be the case. On creating new entry in the DB (say user or roles for example) , it doesn't appear in any default data folder of mySql. How to import data from external tables into Ignitions data bases? It it thru Ignition's Query browser? Is there an automatic way of making Ignition read the imported data (provided the schemas of imported databases match the Ignitions default schema). ---
**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\ **Post date:** [May 16, 2022, 6:49pm UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/2 "2022-05-16T18:49:19Z")
By default, Ignition uses an _Internal_ type of user source named `default`. You can create additional types of user sources that can connect to a database–see [Security](https://docs.inductiveautomation.com/display/DOC81/Security) section of docs, perhaps you’d want to look at [Database Authentication](https://docs.inductiveautomation.com/display/DOC81/Database+Authentication). Do you have any custom user sources defined? ![2022-05-16 at 1.45 PM](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/d/1d0963b6fcb1e0651a103fff08ec31f0b6de23e0.png) ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [May 16, 2022, 6:50pm UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/3 "2022-05-16T18:50:53Z")
Also, any of the DB-based user sources are not tying into the database’s own mechanisms for authentication or authorization - instead, Ignition will generate or use some standard _tables_ in the given DB to store user information. ---
**Author:** ![PRAMANJ](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pramanj/32/66935_2.png) [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Post date:** [May 17, 2022, 5:34am UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/4 "2022-05-17T05:34:36Z")
> [@kcollins](#): > > By default, Ignition uses an _Internal_ type of user source named `default` . You can create additional types of user sources that can connect to a database–see [Security](https://docs.inductiveautomation.com/display/DOC81/Security) section of docs, perhaps you’d want to look at [Database Authentication](https://docs.inductiveautomation.com/display/DOC81/Database+Authentication). > > Do you have any custom user sources defined? Yes I am aware of this from IU courses. However when I create a data based based user source, empty data base and associated tables are created which I have to populate manually one by one adding roles and user names. How can I import data into these tables from an external database (say exported from another project or server). Do I have to do something from mySql data base work bench or simply change some paths such that Ignition sees these tables! I could neither find any Ignition databases in mySql default data folder nor in Ignition's data folder under projects ! ---
**Author:** ![PRAMANJ](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pramanj/32/66935_2.png) [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Post date:** [May 17, 2022, 5:37am UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/5 "2022-05-17T05:37:23Z")
> [@paul-griffith](#): > > Also, any of the DB-based user sources are not tying into the database’s own mechanisms for authentication or authorization - instead, Ignition will generate or use some standard _tables_ in the given DB to store user information. Yes I know Ignition creates a set of standard table for storing user and role data, but where is that stored! I wanted to overwrite these from an existing source of similar tables from say another project or something like that. How to do that was my question. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 17, 2022, 11:31am UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/6 "2022-05-17T11:31:39Z")
> [@prafull\_j](#): > > do something from mySql data base work bench Yes. Commonly statements of the form `Insert Into someTable (...) Select ... From otherTable`. ---
**Author:** ![PRAMANJ](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pramanj/32/66935_2.png) [@PRAMANJ](https://forum.inductiveautomation.com/u/PRAMANJ)\ **Post date:** [May 17, 2022, 3:20pm UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/7 "2022-05-17T15:20:54Z")
From database query browser in the designer? ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [May 17, 2022, 3:28pm UTC](https://forum.inductiveautomation.com/t/database-location-in-ignition/59630/8 "2022-05-17T15:28:54Z")
Should be fine for the designer’s query browser, since it is a single statement.