# Rebuild database without reinstalling everything

**URL:** <https://forum.mautic.org/t/rebuild-database-without-reinstalling-everything/25565>\
**Category:** Product Support\
**Tags:** mautic-4\
**Created:** [October 1, 2022, 1:09pm UTC](https://forum.mautic.org/t/rebuild-database-without-reinstalling-everything/25565 "2022-10-01T13:09:20Z")\
**Posts on this page:** 1\
**Showing post:** 21

<div class="post-metadata">

**Author:** ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent)\
**Post date:** [October 17, 2022, 1:57pm UTC](https://forum.mautic.org/t/rebuild-database-without-reinstalling-everything/25565/21 "2022-10-17T13:57:23Z")

</div>

@techbill, problems apparently start when you (try to) convert the database from MYISAM to InnoDB or/and change collation - utf8\_unicode\_ci or utf8mb4\_sumthing\_?

I think I’ve [solved my original issue](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199/15) related to that, but my database is now a mix of InnoDB and MYISAM - some MYISAM tables won’t convert, not sure if I’d only cause more problems if I forced it somehow. Also not sure what recommended collation etc. is.

I am still curious to see an answer to the original question of this thread, how to do a clean surgical rebuild of the database without losing data and without having to reinstall everything.

---

_[View the full topic](https://forum.mautic.org/t/rebuild-database-without-reinstalling-everything/25565)._
