# 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:** 19

<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 15, 2022, 2:09pm UTC](https://forum.mautic.org/t/rebuild-database-without-reinstalling-everything/25565/19 "2022-10-15T14:09:55Z")

</div>

@Nick_J - I don’t seem to have that path on my server. My Bluehost VPS is configured via WHM/cPanel/EasyApache etc. I don’t think `mariadb` is used anywhere; it’s all `mysql` even if it presumably links to mariadb stuff.

I have `/var/lib/mysql/username_mautic/` - [CentOS default](https://mariadb.com/kb/en/get-the-error-log-of-mariadb/) - with lots of .opt, .frm and .ibd files that Bluefish editor can’t read and in Notepad++ it’s lots of NULL NULL with gibberish sprinkled in. Googling now what this is…

> **FRM file is used by MySQL Server to store table schema and .**  **IBD file is used to store data and indexes of a MySQL database**.

You can only read these .frm and .ibd files “with MySQL”, so I guess somehow via command line or PHPMyAdmin? There is no Windows desktop MySQL client that would be able to read these files I guess?

@joeyk, you asked earlier what `username_mautic` referred to, something I had in my [error message on the other thread](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199/5). It is my mautic database name, as above in `/var/lib/mysql/username_mautic/`.

Could there be a mismatch between how CentOS stores table schema and indexes and how/where Mautic expects it to be done?

---

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