Skip to main content

is there an easy way to migrate fluentcrm from a website to another?

I just want to use fluentcrm where fluentcommunity is installed... and I want to move the plugin's data to another website. Is there an easy way?

nathan Foley

the data is all in the database so just dump it and reinstate it the otherside?

David Vlaic

nathan FoleyΒ how to "dump" it? πŸ˜…πŸ˜…πŸ˜‚

William Beem

David VlaicΒ Here's the beauty of ChatGPT or other AI tools. Ask and it shall provide.

FluentCRM stores its data in its own set of database tables inside WordPress. To move it from one WordPress site to another, you’ll want to export (dump) just those tables and then import them into the new site’s database.

Step 1 – Identify FluentCRM Tables

By default, FluentCRM uses these tables (with your WordPress table prefix, usually wp_):

  • wp_fluentcrm_campaign_emails
  • wp_fluentcrm_campaigns
  • wp_fluentcrm_contact_relations
  • wp_fluentcrm_contact_segment
  • wp_fluentcrm_contact_tag
  • wp_fluentcrm_contacts
  • wp_fluentcrm_forms
  • wp_fluentcrm_funnel_sequences
  • wp_fluentcrm_funnel_subscribers
  • wp_fluentcrm_funnels
  • wp_fluentcrm_lists
  • wp_fluentcrm_meta
  • wp_fluentcrm_subscriber_pivot
  • wp_fluentcrm_tags

(If you use a custom database prefix, replace wp_ with yours.)


Step 2 – Dump the Tables

Here’s a MySQL mysqldump command you can run from the server’s terminal (adjust credentials and prefix as needed):

mysqldump -u your_db_user -p your_db_name 
wp_fluentcrm_campaign_emails 
wp_fluentcrm_campaigns 
wp_fluentcrm_contact_relations 
wp_fluentcrm_contact_segment 
wp_fluentcrm_contact_tag 
wp_fluentcrm_contacts 
wp_fluentcrm_forms 
wp_fluentcrm_funnel_sequences 
wp_fluentcrm_funnel_subscribers 
wp_fluentcrm_funnels 
wp_fluentcrm_lists 
wp_fluentcrm_meta 
wp_fluentcrm_subscriber_pivot 
wp_fluentcrm_tags 
> fluentcrm_backup.sql

This will create a file fluentcrm_backup.sql containing all FluentCRM data.


Step 3 – Import into New Site

On the new WordPress installation (make sure FluentCRM is installed first), import with:

mysql -u your_db_user -p your_new_db_name < fluentcrm_backup.sql

βœ… Tip: If the new site has a different table prefix, you’ll need to search and replace the table names in fluentcrm_backup.sql before importing. For example, change wp_fluentcrm_contacts β†’ newprefix_fluentcrm_contacts.

David Vlaic

William BeemΒ ok. Cool!

nathan Foley

David VlaicΒ I've been beaten to replying but yeah from the database tables as said here get the database tables export and import them I believe this will help and wont require scripts or code https://wordpress.org/plugins/wp-migrate-db/

If I get time I will do a video on it

nathan Foley

David VlaicΒ Here you go -- https://youtu.be/H24FLoeYSkE
This shows you how to do exactly what you want to do in this video

David Vlaic

nathan FoleyΒ wow thanks!

nathan Foley

David VlaicΒ your welcome hopefully it helps remember to backup before working on your database