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?
the data is all in the database so just dump it and reinstate it the otherside?
nathan FoleyΒ how to "dump" it? π π π
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.
William BeemΒ ok. Cool!
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
David VlaicΒ Here you go -- https://youtu.be/H24FLoeYSkE
This shows you how to do exactly what you want to do in this video
nathan FoleyΒ wow thanks!
David VlaicΒ your welcome hopefully it helps remember to backup before working on your database