# Import and Export sqlt data file

**URL:** <https://forum.inductiveautomation.com/t/import-and-export-sqlt-data-file/35533>\
**Category:** Ignition\
**Created:** [June 11, 2020, 5:29am UTC](https://forum.inductiveautomation.com/t/import-and-export-sqlt-data-file/35533 "2020-06-11T05:29:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Oleh](https://avatars.discourse-cdn.com/v4/letter/o/b4bc9f/32.png) [@Oleh](https://forum.inductiveautomation.com/u/Oleh)\
**Post date:** [June 11, 2020, 5:29am UTC](https://forum.inductiveautomation.com/t/import-and-export-sqlt-data-file/35533/1 "2020-06-11T05:29:47Z")

</div>

Hello. I have a sqlt\_data.mm.dd.yy tag archive in my MySQL database with a monthly breakdown of 7 years. Each file is 10 gb. Can I upload files from the database in 6 years and then import them back into the database if necessary. Will newly loaded data in the database be displayed in ignition?

---

<div class="post-metadata">

**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:** [June 11, 2020, 3:31pm UTC](https://forum.inductiveautomation.com/t/import-and-export-sqlt-data-file/35533/2 "2020-06-11T15:31:41Z")

</div>

You _can_ drop individual partitions, but you _must_ also bookkeep the `sqlth_partitions` table at the same time - you’ll notice a record there identifying each of your separate partition tables, along with a start and end timestamp. If those get out of sync, the historian will either not see your restored tables, _or_ error out due to data that’s requested not being present.