By d on Thursday, 12 December 2013
Posted in General
Replies 3
Likes 0
Views 891
Votes 0
I am trying to import my easyblog articles from an old joomla 1.5 site to a new site I already installed easyblog on and made some entries.
I tried doing it in myphpadmin by exporting all the jos_easyblog_ but was running into problems due to the different database prefixes.
Hello D,

Have you change the database prefix? Below is the complete step-by-step guide which you can follow.

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 #__ , 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 #__ 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
8. Enjoy blogging! If you have any problems at this point, drop us an email and we'll take a look at this.

Hope this helps.
·
Thursday, 12 December 2013 11:28
·
0 Likes
·
0 Votes
·
0 Comments
·
I tried that but two things, I already had easyblog installed with some postings on the new site, not sure if that caused the problem, when i tried to import in myphpadmin i get an error: of #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
or #1062 - Duplicate entry '1' for key 'PRIMARY'
d
·
Thursday, 12 December 2013 11:48
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello d,

Seems like the issue is because you have already installed Easyblog on the new site. To perform this migration, you need to remove the Easyblog component from your site including all the tables (#__easyblog_). Then you can import the table based on the steps above. After successfully imported, then only you can install Easyblog. If you have already posted on your latest site, you need to manually recreate it after install. Hope this helps.
·
Thursday, 12 December 2013 12:26
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post