Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Posts
    139
    Thanks
    8
    Thanked 0 Times in 0 Posts

    viewing offline?

    First: I have no experience at all with MySQL. I don't know what it is or what it does, except that it is making my life difficult!

    I have been asked to take over a website. The old site is WordPress-based.

    The company has decided to change hosts and I am to work on an all-new WordPress-based site on the new host.

    Before I was able to gather all the information needed from the old site, the computer guy switched the domain name to the new host. So now I cannot access the WordPress backend on the old host.

    I have downloaded the mySQL database, but have no idea how to view it.

    I tried to upload it to the new host, using phpMyAdmin, but I keep getting an error message.

    I thought if there was a free Windows-based program that I could use to just view the information that is in the database I could get on with it. But I don't know what I am looking for. I have tried a couple but they either don't work or can't access the file, which is on my computer.

    I really only need the text from the pages of the old site - no formatting or images or anything like that. I feel like that should be easy, but so far - for me - it has not been....

    Can anyone help?

    Thanks!

  • #2
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,858
    Thanks
    160
    Thanked 2,223 Times in 2,210 Posts
    Blog Entries
    1
    Check the lines in the DB dump that begins with
    Code:
    INSERT into wp_posts
    (the prefix may not be wp_)
    See http://codex.wordpress.org/Database_...Table_Overview
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •