SQL Problems importing from wordpress.COM to wordpress.ORG

• 

  junesees · Member · Jan 6, 2016 at 11:27 pm

  • Copy link
  • Add topic to favorites

  Hello,

  I am trying to migrate and import content from junesees.wordpress.com to the new site blog.junesees.com.

  I have imported the .xml filed however it did not import all of the drafts and published blog posts on ‘junesees.wordpress.com

  I used the WP official .xml importer.

  I’ve spoken to my hosting agent and they think it’s an incomplete .SQL database that could be causing the problem.

  I was advised by the IT agent to try out a plugin that backs up and downloads a .sql file however there were several error messages.

  Would anyone be able to look and see if it is a .sql database that is causing the problem?

  The blog I need help with is: (visible only to logged in users)

• 

  junesees · Member · Jan 6, 2016 at 11:30 pm

  • Copy link

  I’m Sorry. The blog I need help with is: blog.junesees.com
  The IP address link does not seem to work.

• 

  supernovia · Staff · Jan 7, 2016 at 12:20 am

  • Copy link

  Hi @junesees, does IT mean your database itself is incomplete, or do they mean your XML export is incomplete?

  If it would help, we can redo the export for you. It will automatically split into smaller files if it’s too big. Let us know.

• 

  junesees · Member · Jan 7, 2016 at 12:26 am

  • Copy link

  Hi @supernovia, I think they meant the database from junesees.wordpress.com to blog.junesees.com is incomplete. They kept referring to.

  I’m so sorry I can’t remember! I am not technically savvy.

  Yes please, if you could kindly redo the export, that would help me a lot.

• 

  supernovia · Staff · Jan 7, 2016 at 1:15 am

  • Copy link

  Okay, I’ve just emailed a link. Cheers!

• 

  supernovia · Staff · Jan 7, 2016 at 1:16 am

  • Copy link

  Oh, and this may also help:

  https://en.support.wordpress.com/moving-to-a-self-hosted-wordpress-site/

• 

  junesees · Member · Jan 7, 2016 at 1:19 am

  • Copy link

  Thanks @supernovia!

  Do I need to delete any existing posts that are on the blog.junesees.com and start from scratch importing the .xml files you sent me?

  Or just use imported the files anyway with the WordPress importer?

• 

  supernovia · Staff · Jan 7, 2016 at 4:45 pm

  • Copy link

  You can do whichever seems best. Maybe make a backup of what you’ve got now, import, then if it doesn’t work well, clear it and try again.

  Personally I tend to just import over existing posts unless I’m having some kind of problem.