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

**URL:** <https://forum.mautic.org/t/is-there-a-clean-way-to-manually-import-contacts-etc-via-phpmyadmin/25435>\
**Category:** Product Support\
**Created:** [September 19, 2022, 9:22am UTC](https://forum.mautic.org/t/is-there-a-clean-way-to-manually-import-contacts-etc-via-phpmyadmin/25435 "2022-09-19T09:22:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent)\
**Post date:** [September 19, 2022, 9:22am UTC](https://forum.mautic.org/t/is-there-a-clean-way-to-manually-import-contacts-etc-via-phpmyadmin/25435/1 "2022-09-19T09:22:22Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\
**Post date:** [September 19, 2022, 10:39am UTC](https://forum.mautic.org/t/is-there-a-clean-way-to-manually-import-contacts-etc-via-phpmyadmin/25435/2 "2022-09-19T10:39:01Z")

</div>

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}](https://phoenixnap.com/kb/import-csv-file-into-mysql) \>, its not as smooth as CSV import in mautic, but it is possible.

---

<div class="post-metadata">

**Author:** ![modifiedcontent](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/modifiedcontent/32/511_2.png) [@modifiedcontent](https://forum.mautic.org/u/modifiedcontent)\
**Post date:** [September 19, 2022, 11:38am UTC](https://forum.mautic.org/t/is-there-a-clean-way-to-manually-import-contacts-etc-via-phpmyadmin/25435/3 "2022-09-19T11:38:17Z")

</div>

Thanks @mzagmajster.

The smooth [CSV import in Mautic doesn’t work](https://forum.mautic.org/t/csv-imports-fail-stalling-in-progress-runtime-less-than-1-second/25199/9) 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. 🙂

---

<div class="post-metadata">

**Author:** ![mzagmajster](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mzagmajster/32/687_2.png) [@mzagmajster](https://forum.mautic.org/u/mzagmajster)\
**Post date:** [September 19, 2022, 11:40am UTC](https://forum.mautic.org/t/is-there-a-clean-way-to-manually-import-contacts-etc-via-phpmyadmin/25435/4 "2022-09-19T11:40:25Z")

</div>

Totally forgot, I hope you resolve it ASAP

---

<div class="post-metadata">

**Author:** ![techbill](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/techbill/32/8325_2.png) [@techbill](https://forum.mautic.org/u/techbill)\
**Post date:** [September 19, 2022, 9:05pm UTC](https://forum.mautic.org/t/is-there-a-clean-way-to-manually-import-contacts-etc-via-phpmyadmin/25435/5 "2022-09-19T21:05:53Z")

</div>

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 …