covertandcloaked

I’m in a very similar situation with 100’s of text files from a newspaper column I write for a series of Canadian newspapers.

John Wade
https://www.johnwade.ca

Hi Otto,

I don’t know what to tell you. I did (and redid) everything you’ve outlined. It’s just that the posts aren’t there when the blog is pulled up.

I’ve hired someone to have a look and will let you know what form of dementia I contracted.

jw

I hate to be a pest but I really need some help. I’m willing to pay.

I should add that when I do the import I get the following: “Your SQL-query has been executed successfully :
The content of your file has been inserted. (404 Instructions”

jw

I dropped all existing tables (from past installation attempts) and imported the newly created sql file and still nothing. I must be missing something in the steps I outlined above.

Thanks for that. I had read it but I think I’m not grasping parts. One thing I noted on my re read is that its says to check “Add drop table”. I had not done that.

I’ve done a back up with that item checked now but I’m unsure of a further step.

If You Don’t Care If Your Old Blog Works

1. Download a copy of the main wordpress files from your OLD blog to your hard drive and edit wp-config.php to suit the new server.

I’ve done this.

2. Go back to your OLD blog and go to options and change the url (both of them) to that of your new site.

I don’t think this changes in my case but correct me. The server is new I just had the domain dns pointed to my new host.

3. Again, download your database (but keep the old one just in case), upload this new database and the copy of the wordpress core files with the edited wp-config.php to your new server. Thats it!

I’m unclear here as to why I’m asked to download the database again. I suspect that when it says “Again” the author means “As I wrote earlier” as opposed to do it again, but I want to be sure I’m not missing something.

The “upload this new database” seems vague to me which usually means it’s obvious to others, so I would like clarification. It’s referring to importing the old servers sql download into the new one?

If so, should I make sure there are no tables in the new database with the same name as the old or will it rewrite over them?

Thanks, I appreciate your input. I was getting a little discouraged.

jw

When I import via MySQL I receive the following: Your SQL-query has been executed successfully :
The content of your file has been inserted. (668 Instructions)

No posts appear though.