Question about transferring a free WordPress blog to my own hosted solution?

  • Unknown's avatar
    bostonbrits · Member ·

    Hello everyone,

    I wonder if someone can help me please? I’m wanting to transfer my free WordPress blog to my own hosted solution in Network Solutions. Everything is set up to receive the files in Network Solutions and I did an export and imported that XML file into Network Solutions. However, nothing has changed. I called NS and they told me that I need a backup of all the SQL to import into NS… but I cannot figure out for the life of me how to get that data out of a free WordPress site!!! :-(

    Any help gratefully appreciated. Thanks in advance…

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

  • Unknown's avatar
    pavanraheja · Member ·

    Howdy bostonbrits!
    Here is guide to help you with moving your site, which can help you with the full process Moving to Self Hosted
    No SQL is needed for the import and export, just try to do the step again, also if you face any issues with respect to WordPress.org , you can look for help here WordPress org Support

    Hope this helps, let us know for further questions..!

    Regards

  • Unknown's avatar
    bostonbrits · Member ·

    Thanks pavanraheja… I just tried it again with the XML file and I get this error message. I am importing the XML file using phpMyAdmin in Network Solutions. Thanks in advance for any pointers…

    Import has been successfully finished, 1 queries executed.

    The following structures have either been created or altered. Here you can:
    View a structure’s contents by clicking on its name.
    Change any of its settings by clicking the corresponding “Options” link.
    Edit structure by following the “Structure” link.

    (Options)
    (geoffandjenni039stravelblog.wordpress.2017-05-10.xml)
    CREATE DATABASE IF NOT EXISTS DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
    [ Edit inline ] [ Edit ] [ Create PHP code ]

    Error
    Static analysis:

    1 errors were found during analysis.

    The name of the entity was expected. (near “DEFAULT CHARACTER SET” at position 31)
    SQL query:

    CREATE DATABASE IF NOT EXISTS DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    MySQL said: Documentation

    #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 ‘DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 1

  • Unknown's avatar
    pavanraheja · Member ·

    Howdy !
    For getting help on Importing content on WordPress.org this might be of help Importing Content in WordPress if it doesnt help you can get more help at WordPress org Support

    Hope this helps, and you get it the issue resolved soon.

    Regards

  • Unknown's avatar
    bostonbrits · Member ·

    I am not moving to WordPress.org. I am trying to move to Network Solutions. I have installed everything correctly on the NS end, and have managed to import the XML file now with no errors, but still see the default site when I go to the link :-(

    Does something else need to be configured for my exported blog site to work?

    Thanks in advance for anyone’s assistance!

  • Unknown's avatar
    pavanraheja · Member ·

    Hi again..!
    Agreed your trying to move to Network Solution, which is another hosting company, and the site is not hosted on WordPress.com, this forum is for WordPress.com folks only, you are using WordPress but a Selfhosted WordPress , ie wordpress.org software, so I gave the links for finding helpe on WordPress.org support forumWordPress org Support , here is the difference WordPress Com vs WordPress ORG

    Hope this gives clarifcation, let us know for any other questions..!

  • Unknown's avatar
    bostonbrits · Member ·

    OK, thank you…

  • The topic ‘Question about transferring a free WordPress blog to my own hosted solution?’ is closed to new replies.