By Pieter J.van horssen on Wednesday, 28 May 2014
Posted in Technical Issues
Replies 7
Likes 0
Views 3.4K
Votes 0
In order to get my dev site up to the data level with the prod site, I want to export the article tables from prod and import them into my dev site.
Any tips how to do that? Or more explicit, which tables do I need to export/import?
Pieter J.van horssen,

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 it.

*Backup your data first before perform migration

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 Easyblog 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. the "/images/easyblog_avatar", "/images/easyblog_images", "/images/easyblog_shared", and the "/media/com_easyblog" folders and all of their contents).

Hope this help.
·
Wednesday, 28 May 2014 17:35
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks, Arlex
Will give that a whirl.

Pieter
·
Wednesday, 28 May 2014 18:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Pieter J.van horssen,

You're welcome
·
Wednesday, 28 May 2014 18:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I did everything like described. Backend works great, but frontend only shows the headline, no other content. Any Idea?

Regards
Samson
·
Saturday, 22 November 2014 19:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Samson,

Can you provide us your backend and FTP access so we can have a better look on your issue here? Please advise.
·
Saturday, 22 November 2014 21:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I exported now all EasyBlog tables, changed prefix and imported them in the new database. White page was the result. Then I supposed, this might depend on changed settings. The blank installation did work before. So I went back to backup-point. Then I exported the tables again, except the easyblog_configs, changed prefix and imported them. Now it seems to work great. I do not understand this, because versions of all used software is the same.

Perhaps this workaround may help some users.

Thanks for very fast responding time of support, but problem seems to be solved for me. Stackideas is really great!

Regards
Samson
·
Sunday, 23 November 2014 00:30
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks for updating us on this Samson and I am glad that your issues are resolved now
·
Sunday, 23 November 2014 14:11
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post