By Emilio Navas on Thursday, 01 May 2014
Posted in General Issues
Replies 15
Likes 0
Views 1.4K
Votes 0
Hello,
I am renewing my website with a joomlart template and I am interested to backup all my easyblog posts to restore in a test local site with the template example data. Tune and move again to the live site.

Absolutly lost about this. I thought to use Akeeba backup but really I don't know if is the right choice.
Using joomla. 3.2 Any advice?

Thanks in advance,
Emilio
I am trying with Akeeba and looks that I can move the DB in the local test site, but looks like the articles are not there. I restores my images folder and all the easyblog tables. Someone know if I need something more to restore? Thanks :-D
·
Thursday, 01 May 2014 20:27
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Emilio Navas,

Sorry for late reply to this,
Ideally, it's best that you create an export dump through phpmyadmin and export the tables over from live site to test site/ test site to live site. Here's the general guideline that you could use it :

*Remember backup your all data before follow the step below

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.
7. Install the latest EasyBlog on your new site

*Please replace "#__" with your own database prefix


Hope this help.
·
Thursday, 01 May 2014 23:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Alex!
I did as you say and now I have in the local test site all the structure of EasyBlog. I can see the post list but I didn't get the articles, so I can't see the posts.
What more things I need to backup and restore to have all the information and data of whole blog?

Thanks in advance!!!
Emilio
·
Friday, 02 May 2014 00:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Emilio Navas,

What do you mean that "I can see the post list but I didn't get the articles, so I can't see the posts."?

That strange, If you follow my instruction the article should be all show out.

Can i have your Joomla backend and FTP access (and put your sql dump file in your FTP) so we can help you check on this?

May i know your sql dump file is it only export all Easyblog table?
·
Friday, 02 May 2014 00:40
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,
You can see the structure in my live site. Maybe something wrong, I don't know. I can't show you the test site because is in my local computer. I used Akeeba backup to backup the *_Easyblog tables and restore in my local test installation. All the post is under content, articles so I am afraid that is not restored.

What do you think?

I attached all the info in site details tab. I will change the language from Spanish to English to you in the backend of the site. For sure will be easier to you ;-)
·
Friday, 02 May 2014 02:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Emilio Navas,

Sorry for late reply to this,
thanks for take your time provide this details for us
Hmm is it possible temporary upload your test site to live site so that was very helpful to help us to help you investigate on this.

Or do you try uninstall your Easyblog in your local site first and remove all the easyblog table from your database,
then export a sql dump for all the tables that has the prefix of #__easyblog_* from your live site,
then open that sql dump file and edit all the table prefix same as your local database localtableprefix_easyblog_* > save
then import that sql dump file in your local database
After import successfully, then only upload/install the Easyblog component from your backend.

Hope this help.
·
Friday, 02 May 2014 11:51
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex!
you can find the dev site in dev.emilionavas.com ad the live site in http://www.emilionavas.com
Now I can see the posts on fronted and backend but I don't know why not all the pictures appears in the posts. In the backend I can't access to edit any post.

Thanks!
·
Friday, 02 May 2014 19:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Emilio Navas,

Sorry for late reply to this and i missed up 1 more step

You have to manually copy the and that was to copy over the image and media files associated with your live site EasyBlog
e.g. the "/images/easyblog_avatar",
"/images/easyblog_images",
"/images/easyblog_shared",

After you move over the file to your test site and see the image is it can appear? Please advise.
·
Friday, 02 May 2014 19:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Done!
But one of the main problems still continues...
I can't access to the posts in the backend and edit...

Any idea?
Thanks!
·
Friday, 02 May 2014 23:11
·
0 Likes
·
0 Votes
·
0 Comments
·
Replying to follow discussion as this is will be useful
·
Friday, 02 May 2014 23:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Emilio Navas ,

Great I also help you solved just you mentioned that blank page issues, what i did is change your blog editor to TINY-MCE.
Please have a check.

=========================================================================
Hello Peter,

Thanks for heading up on this.
·
Friday, 02 May 2014 23:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Incredible!
Really works. I will never imagine that the problem could be because the html editor.
I will try to download updated version of JCE. Is easier to format text! :-)

Thank you very much for all your help.
Best regards,

Emilio.
·
Saturday, 03 May 2014 00:23
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Emilio Navas,

Great You're welcome, Have a nice weekend.
·
Saturday, 03 May 2014 00:36
·
0 Likes
·
0 Votes
·
0 Comments
·
I hope this is Ok to post here?
If not I will open and start my own post.

I want to do exactly the same the only difference is my original site is a Joomla 2.5. site with easyblog installed and my new site is Joomla 3.3.?

Can I still do this exactly the way you described above?

I also want to do this for my Easydiscuss and Komento component?

Thank you
·
Thursday, 25 September 2014 05:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Leonard Zerman,

Sorry for late reply to this,
Yes, I would personally prefer that you start a new thread instead.
By the way, yes you can follow my above instruction to migrate from your old site to new site.
Note : First thing you need to do is migrate all the Joomla 2.5 user to Joomla 3.3.x first using the 3rd party component, then only continuous my instruction above.
Hope this help.
·
Thursday, 25 September 2014 18:52
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post