New install with prior database possible?

Product Support
1

Your software
My Mautic version is: 2.16.0
My PHP version is:7.2.29
Your problem

My problem is:
Can I migrate to upgraded version and import prior database records?
These errors are showing in the log:

Steps I have tried to fix the problem:

I cannot seem to resolve Mautic log and debug errors that are preventing an upgrade to 2.16.2.

My last alternative is to do a clean install - can I do that while also importing or otherwise bringing in 2.16.0 database records and lists and form and campaign?

Thanks!

2

  1. First install as the older version of database you have

  2. Second upgrade the mautic

  3. Migrate the database

3

Thanks deepti - so I understand are you suggesting I re-install the older version then upgrade, then migrate?

My issue is that I cannot upgrade from 2.16.0 --> 2.16.2 using my existing install. But I gather you are suggesting I re-install 2.16.0 and without any new records or forms or campaigns, upgrade that, then migrate database, correct?

4

On the other hand, why can’t I just do a new install and replace the database references - password and database - in the new install’s config file pointing from the new database to the 2.16.0 database?

5

you can but make sure the new mautic is as old version , so no data will loss. and also you should add all your old mautic files to new one , so you will not get any image(media) broken link etc…

6

Okay so the steps are:

  1. backup and preserve 2.16.0 everything - directories and mysql databases.
  2. reinstall 2.16.0 as a fresh install.
  3. point new install of 2.16.0 to old 2.16.0 database.
  4. upload images, etc,. to new 2.16.0 directories.
  5. attempt upgrade to 2.16.2

Do I have that right?

7

Hi there, I have the same problem as you. My old mautic installation run out and I reinstalled it.
I reupload the database but it does not run. How can I do?

Thanks

8

What version was the original mautic ? you should try and reinstall this version, then mysql -u root mautic < yourdatabase.sql

9

any solution to this?
same problem

10

What I usually do is :

  1. Export the old DB (for example through Phpmyadmin)
  2. Install new Mautic and let it create a new DB (which is empty now).
  3. Import the old DB (for example through Phpmyadmin)
  4. Change the Mautic config (local.php) to use the new DB.

Lex

1 Like
11

The question is:
can someone export a 2.16 DB and import it into 3.2.4? :slight_smile:
I think not. There must be steps to migrate the DB, I just don’t know how.
I always installed an older version of Mautic with a matching DB and upgraded it.

1 Like
12

You are right … I didn’t see that it was 2.16 … silly …

I haven’t tried going from 2.x to 3.x to be honest …

1 Like
13

thanks a lot @joeyk and @lexgabrees . will try to update before migrating.