# Store & Forward and move database

**URL:** <https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371>\
**Category:** Ignition\
**Created:** [April 27, 2012, 6:59pm UTC](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371 "2012-04-27T18:59:59Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jim\_lapratt](https://avatars.discourse-cdn.com/v4/letter/j/cc9497/32.png) [@jim\_lapratt](https://forum.inductiveautomation.com/u/jim_lapratt)\
**Post date:** [April 27, 2012, 6:59pm UTC](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371/1 "2012-04-27T18:59:59Z")

</div>

Would this work or does data get cached in connection for store & forward.

1. Have another MySql server up and going.
2. Duplicate databases and tables in it.
3. Stop ignition database connection, let store & forward store data.  
4)Mirror 2 servers again.
4. Point database connection to new server and start up.
5. Let store & forward start pushing data in and get caught up.

Do any thing you may want to do to original database server, reset up and reverse process.

Will this work??? ![:scratch:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/76d1620bec252bfac07050c889ff5a91dc8a9c25.gif ":scratch:")

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [April 27, 2012, 8:38pm UTC](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371/2 "2012-04-27T20:38:19Z")

</div>

That should work. I don’t see any issues as long as you don’t rename the database connection. You shouldn’t have to do anything in the database either.

---

<div class="post-metadata">

**Author:** ![dberry1](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@dberry1](https://forum.inductiveautomation.com/u/dberry1)\
**Post date:** [December 22, 2017, 12:14am UTC](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371/3 "2017-12-22T00:14:49Z")

</div>

How did it go? I’m about to try something similar. Do you have any advice?  
Thanks.

---

<div class="post-metadata">

**Author:** ![Jonathan\_Bennett](https://avatars.discourse-cdn.com/v4/letter/j/cab0a1/32.png) [@Jonathan\_Bennett](https://forum.inductiveautomation.com/u/Jonathan_Bennett)\
**Post date:** [April 17, 2023, 12:41pm UTC](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371/4 "2023-04-17T12:41:12Z")

</div>

I know it has been 6 years, but did you go through with this? Any advice from your experience?

I need to do this in Ignition 8.1, and it looks like it should still work the same.

---

<div class="post-metadata">

**Author:** ![dberry1](https://avatars.discourse-cdn.com/v4/letter/d/e47c2d/32.png) [@dberry1](https://forum.inductiveautomation.com/u/dberry1)\
**Post date:** [May 11, 2023, 7:09pm UTC](https://forum.inductiveautomation.com/t/store-forward-and-move-database/4371/5 "2023-05-11T19:09:48Z")

</div>

Hello,

These steps worked for me. Store and forward collected the data until the new MySQL server was online then the data was saved to the database.