Since there seems to be no way to fix constant database errors ( and here ) (?), is there a way to manually rebuild the database without having to reinstall everything else or do any Composer crap etc.? In the most surgical, non-invasive way. Something like > export/backup existing data > delete the …

Thanks for the suggestion, @techbill . No it wasn’t. I’ve been on MariaDB since forever/long time as far as I know. @joeyk , I don’t know how it got damaged; I’ve never done anything unusual as far as I know. I do get foreign key constraint errors . At this point I am less interested in figuring out …

OK, I posted on the other forum thread, you mentioned. Do you have special characters in the Mautic user names?

Thanks for response @joeyk . There is only one user on the system, no special characters in username.

Start by analyzing the tables and try to repair the indexes. mysqlcheck is a maintenance tool that allows you to check, repair, analyze and optimize multiple tables from the command line. Read more: https://mariadb.com/kb/en/mysqlcheck/

what is the username_mautic field for?

Thanks @Nick_J - good suggestion. When I run mysqlcheck my_mautic_database, the result is OK for every table. Should I dig deeper? @joeyk referred to this here . When I post code/error message here I usually replace actual usernames, server paths, my own custom prefix, etc. with something like that. …

@cheska It’s disrespectful ! you have to create your own thread.

@Nick_J new users don’t have the permission to create a new post initially but they can reply - so that is probably why they responded to an old thread. I have broken it out as a new post, maybe consider a slightly more empathetic response in future :slight_smile:

Empathy or hypocrisy? I will also troll the discussion by answering you @rcheesley (excuse me @modifiedcontent ) I received a notification for the problem of @modifiercontent, by clicking on the link to come read and help it I come across someone who is participating in the discussion to ask for he…

[image] techbill: MySQL do you have any errors in mariadb logs?

Rebuild database without reinstalling everything

Product Support

Topic		Replies	Views
Issue after restore Database in mautic Product Support	4	327	June 4, 2021
How to recover some data from self hosted? Product Support	12	457	February 2, 2020
Help! Mautic unusable - Contact data scrambled Product Support mautic-4	15	897	September 13, 2022
Issue after restore Database Product Support	8	514	May 13, 2021
Issues when Exporting / Importing DB in Mautic Mautic 4 Install/Upgrade Support	1	350	November 21, 2022

Rebuild database without reinstalling everything

Related topics