Import / Export problem with MySQL (4 posts)

  1. eamonlane
    Posted 9 years ago #

    Yes I am having a problem with MySQL, nothing new there

    I am moving my blog from http://www.eamonlane.com to http://www.stpiduko.com/blog

    eamonlane is hosted by webmania.co.uk and stpiduko is hosted by Godaddy.com

    Everything went according to plan, managed to install wordpress and set up the mysql data base and tested with a simple entry

    As I had the blog on eamonlane for some time I want to be able to transfer all the entries and comments

    using the export freature of mysql on webmania I download files to my pc and then tried to import using mysql on godaddy,

    Yep got errors, I'm told the file is corrupt.

    Just to check if anything was wrong with the new blog I imported using an RSS feed. This worked. but I'm not able to import comments.

    I might be wrong but, webmania uses MySQL 4.01 and I imagine godaddy uses MySQL 5.

    Anyone any ideas on how I can resolve this issue


  2. drmike
    Posted 9 years ago #

    I would use the WordPress XML exporter on your old blog and export it that way. I think 4.01 is too different from 5.

  3. eamonlane
    Posted 9 years ago #

    I tried the backup facility on word press (not too sure if this is xml)

    it's not possible for me to export xml using myPHP admin


  4. nathanieltan1
    Posted 9 years ago #

    I think this will solve the problem; it did for me! :)


Topic Closed

This topic has been closed to new replies.

About this Topic