By Joroslav on Thursday, 10 May 2018
Posted in General
Replies 11
Likes 0
Views 426
Votes 0
on the original site I have easydiscuss version 4.0.15.
On the new site that replaces the original I have only test data and esydiscuss version 4.0.22

I need to convert the entire contents of the esydiscuss to the new site.

How do I do that?

I am talking about deleting and importing database tables.
If you referring migrate your old site Easydiscuss data to your new site Easydiscuss, you have to follow my instruction below :

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 Easydiscuss 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 #__discuss_*
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. (You can check your table prefix from your phpmyadmin : screenshot http://take.ms/eX98f)
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 Easydiscuss on your new site.

**migrate additional - if your discussion post have including the attachment file, you have to do this step as well.
That was to copy over the attachment files associated with Easydiscuss JoomlaFolder/media/com_easydiscuss/attachments/...

Hope this guideline will help much you here.
·
Thursday, 10 May 2018 07:43
·
0 Likes
·
0 Votes
·
0 Comments
·
if I already have an esydiscuss installed, just delete or empty existing tables and import new ones?
·
Thursday, 10 May 2018 19:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, but you have to uninstall all the Easydiscuss like component/plugin/modules from your site backend > extension > manage > manage > search `discuss` this keyword > select all and click uninstall.

Once you uninstalled it, you have to delete all the #__discuss_xx table from your database then continue my instruction at above.
·
Thursday, 10 May 2018 20:59
·
0 Likes
·
0 Votes
·
0 Comments
·
If you do this, the problem is that I lose already created modules quick question module. Is not there another way?
·
Wednesday, 16 May 2018 16:26
·
0 Likes
·
0 Votes
·
0 Comments
·
May i know do you have did any customisation from the Easydiscuss core code?

If dont have, perhaps you can remain those Easydiscuss module then only uninstall Easydiscuss component type from your site backend.
·
Wednesday, 16 May 2018 17:31
·
0 Likes
·
0 Votes
·
0 Comments
·
I've tried the process of deleting tables and importing new tables.
I just reinstall the component and it's okay.
However, I need to keep the table with the layout because the settings are many and I am not looking for the changes made
·
Wednesday, 16 May 2018 17:49
·
0 Likes
·
0 Votes
·
0 Comments
·
Since you already done the migration, perhaps you can do the full backup first then try following steps :

1. Go to your old database > click export > select #__discuss_config > click okay
2. After downloaded, then open this .sql dump file.
3. you will see 'dbversion' and 'config' , copy the whole line start from main_apikey, you can look my screenshot here : http://take.ms/7Kv9m || http://take.ms/kP1Rz
4. Once you copied, then open your new database > open #__discuss_config > click on the structure tab then follow this screenshot : http://take.ms/TzEWF
5. Then create a new column call id http://take.ms/yktPe
6. Go back to browse tab > double click that config value columns then select all and replace back just you copied that code from .sql dump file http://take.ms/Qdv7a

Note : Before you replace the code, you have to copy out those code, in case you include some of the invalid character, so you can revert back to the original code.
·
Wednesday, 16 May 2018 18:14
·
0 Likes
·
0 Votes
·
0 Comments
·
no, conversely, I need to keep configuring the new site, just dragging old data.
I'm testing a few options to find the right path, writing it here
·
Wednesday, 16 May 2018 19:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Alright, keep us update if you need any further assistance on this.
·
Wednesday, 16 May 2018 19:35
·
0 Likes
·
0 Votes
·
0 Comments
·
data transfer from the old site and the older version of easydiscuss to the new site and last easydiscuss.
1. Back up your new web site including the database
2. Export the database table #_discuss_configs
3. Delete all tables # _discuss_ * in the new site database
4. import all #discuss_ * tables from the old site to the new one
5. Reinstall asydiscuss (enough component, addon is not needed)
6. restore the #_discuss_configs table from the backup

That is all.
·
Wednesday, 16 May 2018 23:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, that is correct step to do this if you would like to keep your new site Easydiscuss config setting.
·
Thursday, 17 May 2018 09:57
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post