By Daniel Garcia on Tuesday, 15 January 2013
Posted in General
Replies 4
Likes 0
Views 2.8K
Votes 0
Hi guys,

Thanks in advance for reading my post and for the software. It is pretty good.


I have read a couple of threads that roughly touches this issue but I do not have it very clear. I am trying to export all my blog entries from Joomla 1.5! to a new fresh installation over Joomla! 3.0. I don't care about:

1-) Authors as there is only one and is the same joomla's admin
2) Comments as we did not allow on Joomla! 1.5
3) Hits, Tags, etc... No such things are interesting for us now.

All we care about is the blog entries and the categories that each entry is associated with. That is it! Could you guys please confirm that all that I need to do is to export _post, _category and _features and import them onto my new installation? Are there changes on the attributes of such tables in the different version of the software? For example, missing attributes or different type of attributes?

I have tried to reverse-engineer the relational model to get the ER but either you are using MyIsam or Innodb without referential integrity so I could not track down very well the foreign keys.

Regards,
Daniel.
Just following up on this thread.

I want to export over 1500 posts from a 1.5 to 3.0 site.

I am guessing there is no export feature at this point?

Is it just a question of exporting the DB tables and importing into Joomla 3.0 DB?

What changes would have to be made?
·
Sunday, 22 June 2014 00:42
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Hans Desjarlais,

I am really sorry for the delay of this reply as it is a weekend for us here.
Ideally, it's best that you create an export dump through phpmyadmin and export the Easyblog tables over. Here's the general guideline that you could use and it is also what we used previously when we migrated from Joomla 1.x 2.x to Joomla 3.x.

*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 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 Joomla 3.3

**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 guideline help.
·
Sunday, 22 June 2014 09:00
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Arlex,

Thanks for your clear instructions. They make perfect sense to me.
However, when I try to import the .sql file into the NEW website database I get an error message:

ERROR:
SQL query:

--
-- Dumping data for table `acsrz_easyblog_acl`
--

INSERT INTO `acsrz_easyblog_acl` (`id`, `action`, `default`, `description`, `published`, `ordering`) VALUES
(1, 'add_entry', 1, 'If allowed, user is allowed to post a new blog post.', 1, 0),
(2, 'publish_entry', 1, 'If allowed, user is allowed to publish their blog post on the site. ', 1, 0),
(3, 'allow_feedburner', 1, 'If allowed, user can set their own Feedburner URL which will be linked to their own blog.', 1, 0),
(4, 'upload_avatar', 1, 'If allowed, user can upload their avatar.', 1, 0),
(5, 'manage_comment', 1, 'If allowed, user can manage any comments that are posted throughout the site.', 1, 0),
(6, 'update_twitter', 1, 'If allowed, user can post updates to their own Twitter account.', 1, 0),
(7, 'update_tweetmeme', 1, 'If allowed, user can update Tweetmeme settings. **Deprecated**', 0, 0),
(8, 'delete_entry', 1, 'If allowed, user can delete their own blog post.', 1, 0),
(9, 'add_trackback', 1, 'If allowed, user can specify[...]

MySQL said:
#1062 - Duplicate entry '1' for key 'PRIMARY'


I'm not sure what this means. Do you know how I can fix this?

All I'm looking to do is export the blog entries from my old website to my new one.

Thanks!
Ryan
·
Wednesday, 06 August 2014 04:24
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Ryan,

It's most likely that you have installed EasyBlog on your new site before running the SQL query above. You can actually ignore this table since this table is already populated during the installation of EasyBlog.
·
Wednesday, 06 August 2014 13:20
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post