Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
Thread: viewing offline?
01-24-2012, 08:33 AM #1
- Join Date
- Jun 2002
- Thanked 0 Times in 0 Posts
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?
01-24-2012, 09:05 AM #2
- Join Date
- Mar 2007
- Thanked 2,223 Times in 2,210 Posts
- Blog Entries
Check the lines in the DB dump that begins with(the prefix may not be wp_)Code:INSERT into wp_posts