# Ignition data from MySQL

**URL:** <https://forum.inductiveautomation.com/t/ignition-data-from-mysql/27751>\
**Category:** Ignition\
**Created:** [August 26, 2019, 7:38am UTC](https://forum.inductiveautomation.com/t/ignition-data-from-mysql/27751 "2019-08-26T07:38:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![miculacristianradu](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@miculacristianradu](https://forum.inductiveautomation.com/u/miculacristianradu)\
**Post date:** [August 26, 2019, 7:38am UTC](https://forum.inductiveautomation.com/t/ignition-data-from-mysql/27751/1 "2019-08-26T07:38:31Z")

</div>

Hello guys,

I have a question regarding the MySQL default database that is connected to Ignition. Our database server is very low on disk and we want to delete some data.

 ![mysql%20conn%20ignition](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/abe930b704b717dabb76d3aff4bae62e92a0d957.jpeg)  
 ![mysql%20conn](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9a83b83d6f64e1d8f6c254b951ef72d2e7513194.jpeg)

I noticed that the “ProgramData” folder from MySQL saves data month by month in form of: .IBD, .FRM

 ![back-up%20mysql](https://us1.discourse-cdn.com/inductiveautomation/original/2X/f/f3d5a20961d161170ec253090eac50dab3a9f7b5.jpeg)

My question is:

This data is the historical data for each month? Or is the data for all the months from the beggining?

Can I delete this data or copy them on another server and acces them only if we need to?

Thank you!!

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [August 26, 2019, 12:20pm UTC](https://forum.inductiveautomation.com/t/ignition-data-from-mysql/27751/2 "2019-08-26T12:20:39Z")

</div>

Why not setup pruning, let Ignition delete on it’s own? Pruning is turned off by default, turn it on and then set the age to what you think you will need.

[https://www.inductiveuniversity.com/video/data-partitioning-and-pruning/7.9](https://www.inductiveuniversity.com/video/data-partitioning-and-pruning/7.9)