# Mautic Migration to another server - different SQL credential - local.php not found

**URL:** https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911
**Category:** Product Support
**Created:** [April 8, 2021, 7:16am UTC](https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911 "2021-04-08T07:16:39Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![mauticuser1245](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mauticuser1245/32/433_2.png) [@mauticuser1245](https://forum.mautic.org/u/mauticuser1245)
#### Post date: [April 8, 2021, 7:16am UTC](https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911/1 "2021-04-08T07:16:39Z")

</div>

**Your software**  
My Mautic version is: 3.1.2  
My PHP version is: 7.3.27-9  
My Database type and version is: Ver 15.1 Distrib 10.3.25-MariaDB

Hello,

I’m unable to find SQL credentials in mautic config files in order to migrate mautic to another server.

I have tried to find local.php but it’s missing, i have opened and check inside config.php, config\_prod.php, security.php, parameters.php.

I’m unable to find documentation with the location of the actual SQL credentials.

Anyone can help me with that?

Regards,

---

<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: [April 8, 2021, 9:09am UTC](https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911/2 "2021-04-08T09:09:02Z")

</div>

Weird. Should be in /app/config/local.php

---

<div class="post-metadata">

### Author: ![mauticuser1245](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mauticuser1245/32/433_2.png) [@mauticuser1245](https://forum.mautic.org/u/mauticuser1245)
#### Post date: [April 8, 2021, 9:10am UTC](https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911/3 "2021-04-08T09:10:43Z")

</div>

How can i do to migrate it without loss of data?

---

<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: [April 8, 2021, 9:53am UTC](https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911/4 "2021-04-08T09:53:58Z")

</div>

You need:

- DB
- files of your Mautic folder (also invisible files starting with .)

- in your local.php  
‘site\_url’ =\>

Make sure DB version is according to your local.php settings.

---

<div class="post-metadata">

### Author: ![mauticuser1245](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mauticuser1245/32/433_2.png) [@mauticuser1245](https://forum.mautic.org/u/mauticuser1245)
#### Post date: [April 8, 2021, 11:05am UTC](https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911/5 "2021-04-08T11:05:32Z")

</div>

Ok, i just find out that i was in the wrong vhost…

Files are present (local.php too), the problem is that all the environment will change, do i need to change all path in the file ?

Like, for example :

```
    'cache_path' => '/var/www/html/app/../var/cache',
    'log_path' => '/var/www/html/app/../var/logs',

```

Do i need to search&remplace “/var/www/html/” to "/web/mutual/mautic1/ or only the “db\_xxx” are important?

Can i after this, upgrade to mautic 3 ?

Thanks for your help.

---

<div class="post-metadata">

### Author: ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)
#### Post date: [April 8, 2021, 1:21pm UTC](https://forum.mautic.org/t/mautic-migration-to-another-server-different-sql-credential-local-php-not-found/18911/6 "2021-04-08T13:21:22Z")

</div>

Changing the path from previous path is required in local.php. I use replace all function in emeditor
