# Preventing a sql script from running again?

**URL:** <https://forum.ansible.com/t/preventing-a-sql-script-from-running-again/12336>\
**Category:** Ansible Project\
**Created:** [February 11, 2013, 9:09am UTC](https://forum.ansible.com/t/preventing-a-sql-script-from-running-again/12336 "2013-02-11T09:09:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tin\_Tvrtkovic](https://avatars.discourse-cdn.com/v4/letter/t/bc8723/32.png) [@Tin\_Tvrtkovic](https://forum.ansible.com/u/Tin_Tvrtkovic)\
**Post date:** [February 11, 2013, 9:09am UTC](https://forum.ansible.com/t/preventing-a-sql-script-from-running-again/12336/1 "2013-02-11T09:09:51Z")

</div>

I generally drop the database before hand and recreate it (as was suggested by a few of the regulars here a few weeks ago). Sure you’ll lose all your data, but it’s idempotent and will apply any potential changes to the schema.

---

<div class="post-metadata">

**Author:** ![Michael\_DeHaan](https://avatars.discourse-cdn.com/v4/letter/m/c4cdca/32.png) [@Michael\_DeHaan](https://forum.ansible.com/u/Michael_DeHaan)\
**Post date:** [February 11, 2013, 1:10pm UTC](https://forum.ansible.com/t/preventing-a-sql-script-from-running-again/12336/2 "2013-02-11T13:10:54Z")

</div>

That's terrible! 🙂