By David on Wednesday, 23 September 2015
Posted in Technical Issues
Replies 11
Likes 0
Views 1K
Votes 0
Hello,

I need to migrate content from one easyblog site to the new design of that same site. I was looking for a backend UI way to export the users and their posts into the new system. Have I missed the obvious?

I found migrate option and thought it might generate a file I could export/import but trying and reading the documentation i'm getting nowhere.

http://veritefitness.co.uk/blogs/verite-fitness-blog-whats-new.html (old site) >
http://veritefitness.co.uk/new/index.php/verite-fitness-blog.

Many thanks I've been asked to complete this by tomorrow so if you are able to a response would be really appreciated.

Thank you and sorry for an inappropriate amount of notice time
Hello David,

I'm sorry for the delay of my previous reply as here we had a public holiday yesterday. Based on you reply above, did you resolved the issue by yourself?
·
Friday, 25 September 2015 18:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello David,

I'm sorry but we don't have migrator to export Easyblog table. If the different between two sites is only the design, you can migrate all the Easyblog tables manually from one database to another using phpmyadmin. Make sure you follow the table prefix of the new database. Please give it a try. You may want to backup your new site before migrating.
·
Wednesday, 23 September 2015 16:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Okay, thank you. Changed the prefix so it's the same on both sites, backed up both db's. However on first try importing the relevant tables only wiped out the other pre-existing tables.

Looking through import options and trying to find tutorial (never used phpmyadmin before like this) do I need to change the export options for easyblog tables or change the import setting on new site so it adds to not deletes the other tables?

I have tried Googling this before asking but can't seen to find a relevant tutorial on partial export and adding to import.

Many thanks
·
Wednesday, 23 September 2015 17:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello David,

You can provide us your phpmyadmin so we can help you do the import/export process. You need to tell us which one is the old and new database.
·
Wednesday, 23 September 2015 17:09
·
0 Likes
·
0 Votes
·
0 Comments
·
I'm sorry I can't and setting up new users - since it's not my system, I'd also really appreciate knowing how to do this myself anyway so in the future I can fix it without asking for help. Less work for you!!! (since we are going to be purchasing easyblog developer and doing a lot of installs).

If you can just tell me the correct export setting and import settings I'll be fine though.

Many thanks
·
Wednesday, 23 September 2015 17:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello David,

What I always did is tick the DROP Table syntax when exporting tables. When importing table in your new site, it will drop all your current table and insert the exported table from the old site. Be sure to only export Easyblog tables and not all tables in your database.
·
Wednesday, 23 September 2015 17:38
·
0 Likes
·
0 Votes
·
0 Comments
·
I'm sorry if this process is not quicker for you now than just logging in, but it will mean I won't need to ask for further help in future

Just to clarify you leave the current default setting when exporting the easyblog table and just tick "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement" (screenshot attached)

"it will drop all your current table and insert the exported table from the old site" Secondly I still need to keep the new existing non-easyblog tables.

Is there a tutorial of what you are describing? or just alter the attached screenshot showing the correct settings.

Thank you again
·
Wednesday, 23 September 2015 18:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello David,

I'm sorry, there is no tutorial. Yes, you need to tick all these: http://screencast.com/t/DVDjRBRe and leave the rest as it is. And make sure you have to only export the Easyblog Tables. Not the whole database. The drop statement will based on what table you are exporting. If you select Easyblog tables, it will drop only Easyblog tables.
·
Wednesday, 23 September 2015 18:30
·
0 Likes
·
0 Votes
·
0 Comments
·
I've deleted the posts that were here asking for help, as I've done it manually myself.
·
Friday, 25 September 2015 09:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello David,

I'm sorry as I am a bit lost here. What do you mean by your last reply?
I've deleted the posts that were here asking for help, as I've done it manually myself.
·
Friday, 25 September 2015 10:28
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello David,

I wrote back 3 or 4 times for advice a couple of days ago but heard nothing. I created you access to the db's in the end but never heard back from yourself so I deleted these posts with information on regarding access to phpmyadmin db's and copied the blog over manually myself post by post.
The import did not work with what we discussed above. It did not copy over the authors therefore the posts were not assigned to anyone other than guest and I could not save the changes. So created the authors manually, changed the post author to one of the new authors and then was able to change content like adding images and save.
·
Friday, 25 September 2015 17:34
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post