Ideally, it's best that you create an export dump through phpmyadmin and export the tables over. Here's the general guideline that you could use and it is also what we used previously when we migrated from old site to new site.

*Backup your data first before perform migration
*Migrate all the old site user to new site first using 3rd party extension (make sure all the user id is same as old site)
*Don't Install Easyblog in your new site.

1. Open up PHPMyAdmin tool that is provided by your hosting provider and open up your current site's database.
2. Make a sql dump for all the tables that has the prefix of #__easyblog_*
3. Download the .sql file and save it on your desktop.
4. If your new site's database prefix also uses the same prefix , then you can skip this part. However, if you are using a different database prefix, you'll need to edit the .sql file that you've just downloaded, and do a search and replace of jos_ with your new database prefix.
5. Open your PHPMyAdmin and this time, open up your new site's database.
6. You should see an import link at the top. Click on that, and click on browse. Select the .sql file and click the run import button.
Note : 7. Install the latest EasyBlog on your new site

**migrate additional - if your blog post have including the image file, you have to do this step as well.
That was to copy over the image and media files associated with EasyBlog e.g.
images/easyblog_tavatar/
images/easyblog_cavatar/
images/easyblog_avatar/
images/easyblog_shared/
images/easyblog_images/
images/easyblog_articles/

Thanks so much - worked perfectly (for the database) just about to move the images

i have noticed that although i have the domain listed in my account - it is telling me that i don't have a subscription

this is obviously a testing url - so i will need to change it when we go live - but in the meantime - how do i get my subscription to be recognized?

the test domain is
http://144.208.70.12/~phil3/
or http://siteminder247.com/~phil3/

any suggestions
;-)

oops - spoke a little too soon!

easyblog seems to work well in the backend - images and database - settings etc.

although the page no longer loads with the following error

1054 - Unknown column 'a.notify' in 'where clause' SQL=select a.`id`, a.`user_id`, b.`name`, b.`email` from `#__easyblog_oauth` as a inner join `#__users` as b on a.`user_id` = b.`id` where a.`type` = 'facebook' and a.`notify` = '0' and a.`system` = '1' and a.`expires` <= DATE_ADD('2017-03-15 23:03:33', INTERVAL 7 DAY)

any ideas please?

although the page no longer loads with the following error

1054 - Unknown column 'a.notify' in 'where clause' SQL=select a.`id`, a.`user_id`, b.`name`, b.`email` from `#__easyblog_oauth` as a inner join `#__users` as b on a.`user_id` = b.`id` where a.`type` = 'facebook' and a.`notify` = '0' and a.`system` = '1' and a.`expires` <= DATE_ADD('2017-03-15 23:03:33', INTERVAL 7 DAY)

It seems like you missing this `notify` column from this table #__easyblog_oauth , can you try run this following SQL and see how it goes?

// Replace your #__ to your table prefix

alter table `#__easyblog_oauth` add column `notify` tinyint(1) DEFAULT '0';

i have noticed that although i have the domain listed in my account - it is telling me that i don't have a subscription

this is obviously a testing url - so i will need to change it when we go live - but in the meantime - how do i get my subscription to be recognized?

the test domain is
http://144.208.70.12/~phil3/
or http://siteminder247.com/~phil3/

Can you try download full installer from https://stackideas.com/dashboard then upload through your Joomla installer page , remember select "Install from directory" method and select the component file and see how it goes.

thanks so much - seems to be working

;-)
much appreciated

Hi there,

You are most welcome. Glad to hear that your issue has been resolved now.

As a gentle reminder, kindly start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiry. I will lock and mark this thread as resolved.