# Issue after restore Database

**URL:** <https://forum.mautic.org/t/issue-after-restore-database/19416>\
**Category:** Product Support\
**Created:** [May 11, 2021, 3:02pm UTC](https://forum.mautic.org/t/issue-after-restore-database/19416 "2021-05-11T15:02:13Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\
**Post date:** [May 11, 2021, 3:02pm UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/1 "2021-05-11T15:02:13Z")

</div>

**Your software**  
My Mautic version is: 3.3.1  
My PHP version is: PHP 7.3.27  
My Database type and version is: Server version: 8.0.23 MySQL Community Server - GPL

**Your problem**  
My problem is: After restoring my database, I cannot access Mautic. I get the following message “Internal server error 500”. I only export and import the database to a new server, I did not modify anything else, is it necessary to modify any file to establish the connection?

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [May 12, 2021, 6:46am UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/2 "2021-05-12T06:46:25Z")

</div>

Hello @nataly sorry for your trouble.  
Normally you don’t need to modify anything. If you don’t have db access, you would see a ‘Cannot Establish DB connection’ error. This is not the case. Make sure your files are writable and you have the right permission set. I mean file ownership.  
Joey

---

<div class="post-metadata">

**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\
**Post date:** [May 12, 2021, 9:11am UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/3 "2021-05-12T09:11:32Z")

</div>

What files are you referring to exactly?

The process that I have carried out is the following:

1. I created the backup of the Mautic database and downloaded it.
2. From the PHPmyadmin page, of the new server to which I want to migrate the information, I deleted all the tables of the Bitnami\_mautic database and imported the structure of the database that I was going to migrate (I don’t know if the error could be there , maybe I deleted some table that is necessary for the connection) once I had the new database structure, I loaded all the data from the database by command, since it is a file that weighs about 1GB.
3. The database is loaded correctly, I know, because now it allows me to enter the website with a username and password that were in the data that I imported. But once I log in, I get the following error.  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/e/e72e8e82553b6eb968f2be4365dade05d7bc3821.png)

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [May 12, 2021, 11:06am UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/4 "2021-05-12T11:06:20Z")

</div>

You will have to get your hands dirty:  
Can you check logs and see if there is anything relevant?  
Joey

---

<div class="post-metadata">

**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\
**Post date:** [May 13, 2021, 12:02pm UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/5 "2021-05-13T12:02:54Z")

</div>

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/010\_resize\_fs…

resize2fs 1.44.5 (15-Dec-2018)  
The filesystem is already 5209856 (4k) blocks long. Nothing to do!

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/020\_hostname…

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/030\_swap\_file…

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/040\_stack\_etc…

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/050\_clean\_pids…

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/060\_check\_if\_demo\_machine…

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/070\_change\_boot\_log\_permissions…

## 2021-05-13 11:30:19+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/080\_prevent\_incoming\_connections…

## 2021-05-13 11:30:21+00:00 ## INFO ## 80 has been blocked

## 2021-05-13 11:30:24+00:00 ## INFO ## 443 has been blocked

## 2021-05-13 11:30:24+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/090\_get\_default\_passwords…

## 2021-05-13 11:30:24+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/100\_regenerate\_keys…

## 2021-05-13 11:30:24+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/110\_configure\_default\_passwords…

## 2021-05-13 11:30:24+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/120\_reenable\_incoming\_connections…

## 2021-05-13 11:30:24+00:00 ## INFO ## Running /opt/bitnami/var/init/pre-start/130\_gce\_initialize\_monitoring…

Restarting stackdriver-agent (via systemctl): stackdriver-agent.service.

![](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/2/2daeaa8b5f19f0bc209d976c02bd6acb51b00b0a.gif)ᐧ

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [May 13, 2021, 1:45pm UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/6 "2021-05-13T13:45:40Z")

</div>

Can you check plz these logs?  
MAUTICFOLDER/var/logs/  
thx

Joey

---

<div class="post-metadata">

**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\
**Post date:** [May 13, 2021, 2:02pm UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/7 "2021-05-13T14:02:24Z")

</div>

[quote=“joeyk, post:6, topic:19416”]  
MAUTICFOLDER/var/logs/  
[/quote]  
That is the folder that I have previously verified, what I have written to you is what appeared in the pre-start.log log  
there is also another log called post-start.log and it says the following:

```
## 2021-05-13 11: 30: 40 + 00: 00 ## INFO ## Running / opt / bitnami / var / init / post-start / 010_bitnami_agent_extra ...
## 2021-05-13 11: 30: 40 + 00: 00 ## INFO ## Running / opt / bitnami / var / init / post-start / 020_bitnami_agent ...
## 2021-05-13 11: 30: 40 + 00: 00 ## INFO ## Running / opt / bitnami / var / init / post-start / 030_update_ip ...
## 2021-05-13 11: 31: 23 + 00: 00 ## INFO ## Running / opt / bitnami / var / init / post-start / 040_update_welcome_file ...
## 2021-05-13 11: 31: 23 + 00: 00 ## INFO ## Running / opt / bitnami / var / init / post-start / 050_bitnami_credentials_file ...
## 2021-05-13 11: 31: 23 + 00: 00 ## INFO ## Running / opt / bitnami / var / init / post-start / 060_start_gonit ...
Starting gonit daemon
## 2021-05-13 11: 31: 23 + 00: 00 ## INFO ## Running / opt / bitnami / var / init / post-start / 070_clean_metadata ...
```

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [May 13, 2021, 2:03pm UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/8 "2021-05-13T14:03:41Z")

</div>

Do you have something like “prod-2021-05-13.php”?  
Thx

---

<div class="post-metadata">

**Author:** ![nataly](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/nataly/32/441_2.png) [@nataly](https://forum.mautic.org/u/nataly)\
**Post date:** [May 13, 2021, 2:59pm UTC](https://forum.mautic.org/t/issue-after-restore-database/19416/9 "2021-05-13T14:59:02Z")

</div>

Nop, just these two files that I mentioned
