Is there a clean way to manually import Contacts etc. via PhpMyAdmin?

Product Support
1

Is there a clean way to manually import Contacts etc. via PhpMyAdmin when the application is broken?

Your software
My Mautic version is: v4.4.2
My PHP version is: 7.4.30
My Database type and version is: 10.3.36-MariaDB

2

You should really focus on getting your mautic working again, first before doing import.

Nevertheless, it seems there is an option to insert data via php my admin: < How to Import a CSV File in MySQL? {Command Line or phpMyAdmin} >, its not as smooth as CSV import in mautic, but it is possible.

1 Like
3

Thanks @mzagmajster.

The smooth CSV import in Mautic doesn’t work and it will probably take me weeks to figure out how to fix it. I need a way to keep my business going; this should do it. :slight_smile:

4

Totally forgot, I hope you resolve it ASAP

1 Like
5

Yes and no …

In PhpMyAdmin you can go to your Mautic database and select the table Lead then do a PhpMyAdmin export using CSV but it’ll export everything including anonymous contacts if I recalled correctly into CVS so it not exactly “clean”.

What I would do is a SQL export in PhpMyAdmin then do a fresh Mautic install on another location with a new database then do a SQL import into the fresh installation …