WordPress.org

1. Blue Collar Todd
   Member
   Posted 7 months ago #

   I loaded my export file into WordPress after switching host servers. For some reason the last six months of posts are missing. Any ideas?

2. Brad Markle
   Member
   Posted 7 months ago #

   How exactly did you export the data? For example, do you have an xml file?

   If you have A LOT of posts, when WordPress exported your data, it may have hit a memory error or max execution time error and resulted in incomplete data. Take a look at your exported file using notepad, and check to see if there are any error messages at the bottom of the file.

3. Blue Collar Todd
   Member
   Posted 7 months ago #

   It was about 35 MB and someone recommended using a file splitter to load them. I can only load up to 8 MB on the import screen. I could look for an older exported file, maybe a few weeks ago and split that up to load. Or would you recommend another option?

4. Brad Markle
   Member
   Posted 7 months ago #

   Wow, 35MB?! Sounds like you have quite a few posts?

   Have you thought about exporting your posts directly from phpMyAdmin on your old server, and then importing them again within phpMyAdmin on your new server?

5. Blue Collar Todd
   Member
   Posted 7 months ago #

   I think I tried something like that with them on the phone. I downloaded an SQL file. Would sound right to you? So I did upload that to the new server via their webpage, but not sure if I am supposed to do something after that because nothing changed on my page.

6. Brad Markle
   Member
   Posted 7 months ago #

   Thanks for getting back with me. You'll need to do a little more besides uploading the .sql file to your account. You'll need to use phpMyAdmin to import that .sql file.

   Restoring Your Database From Backup

   1. Login to phpMyAdmin.
   2. Click databases, and select the database that you will be importing your data into.
   3. You will then see either a list of tables already inside that database or a screen that says no tables exist. This depends on your setup.
   4. Across the top of the screen will be a row of tabs. Click the Import tab.
   5. On the next screen will be a Location of Text File box, and next to that a button named Browse.
   6. Click Browse. Locate the backup file stored on your computer.
   7. Make sure the SQL radio button is checked.
   8. Click the Go button.

7. Brad Markle
   Member
   Posted 7 months ago #

   Hi Blue Collar Todd, have you been able to make any progress on this issue?

8. Blue Collar Todd
   Member
   Posted 7 months ago #

   The file will not upload. Keeps failing. I've been on the phone with the host server and they keep trying new things but nothing works. I try re-loading the XML file as well but the server times out if I click on the box to upload all the attachments. If I don't click on that box "files and attachments", it loads but still only up to April.

9. Brad Markle
   Member
   Posted 7 months ago #

   If phpMyAdmin will not accept the .sql file, most likely it is too big and you're hitting some kind of memory error.

   What you'll want to do is:
   1. upload the .sql file to your account using ftp
   2. contact your host, tell them where you uploaded the file and to which database you need it restored to

   Your host should be able to import the .sql file via the command line, bypassing any issues that phpMyAdmin would give due to memory and other limits.

10. Blue Collar Todd
    Member
    Posted 7 months ago #

    I put it in their FTP file manager and db-backups folder. It did upload there, but it failed to restore after that. I did this while talking to them on the phone, have spent many hours troubleshooting, still can't figure it out. Looking for any other options.

11. Brad Markle
    Member
    Posted 7 months ago #

    I put it in their FTP file manager and db-backups folder. It did upload there, but it failed to restore after that.

    Did you simply upload the file and that's it, or did you take any action after that?

    If you did not have your host help, tell them that you uploaded the file to the db-backups folder and ask they restore it for you.

12. Blue Collar Todd
    Member
    Posted 7 months ago #

    Yeah, did the restore with them after that and it failed.

13. Brad Markle
    Member
    Posted 7 months ago #

    Great, we're at least making some progress! It is vital that we have an error message to go off of. When it failed, did they give you an error message?

14. govpatel
    Member
    Posted 7 months ago #

    You will need drop all tables in database and then import if the file to big then you can export in zip format and then import the zip file.

15. Blue Collar Todd
    Member
    Posted 7 months ago #

    Here's where things stand: They: Go Daddy, told me the error was on line 22, so they had me open the SQL file, used Notepad and deleted line 22. I saved that file under a new name. I am backing up what is there now (database) so I don't lose the last few days of posts and have also downloaded an export file via WordPress dashboard.

    They want me to upload that new file with line 22 deleted to see if that works. Thoughts?

16. Brad Markle
    Member
    Posted 7 months ago #

    What is on line 22? Some lines contain quite a bit of content, so deleting one line could result in a loss of quite a bit of content.

17. Blue Collar Todd
    Member
    Posted 7 months ago #

    No idea, just told that was the line the error was on. I figure at this point I have everything saved and could resort to the current state if I don't like what happens next.

18. Blue Collar Todd
    Member
    Posted 7 months ago #

    I adjusted a setting in the Dashboard under Writing where it says something about XML files. Reloaded my original export file, and got post back up August, well half of August. So that was good. I didn't do anything with that SQL file yet.

    It timed out on me and said something about an error on Port 80. I wonder if I get rid of that error it would load the rest of my old posts? This is all through the WordPress dashboard.

19. Brad Markle
    Member
    Posted 7 months ago #

    It timed out on me and said something about an error on Port 80.

    Port 80 is the default port for website traffic. If you get that error again, please respond with the EXACT error message, it will help quite a bit ;)

20. Blue Collar Todd
    Member
    Posted 7 months ago #

    Here it is: Apache Server at bluecollarphilosophy.com Port 80

    I get that if I try and upload the file with the attachment box checked. Now if that is not checked it loads without the error but still no posts from September, but that is a huge improvement from April.

21. Blue Collar Todd
    Member
    Posted 7 months ago #

    I am also getting a lot of 404 Errors on posts that I know are there.

22. Brad Markle
    Member
    Posted 7 months ago #

    I'm sorry that this issue hasn't been resolve yet. Personally I find it much easier to debug an issue when I can be hands on.

    Here's where things stand: They: Go Daddy, told me the error was on line 22, so they had me open the SQL file, used Notepad and deleted line 22.

    Can you upload the original .sql file (before you deleted line 22) and provide a link so we can review?

23. Blue Collar Todd
    Member
    Posted 7 months ago #

    I have the original file but not sure how to upload a file for you to view it. I could past in the text in a block quote?

24. Brad Markle
    Member
    Posted 7 months ago #

    Sorry for the delay. Since you already have hosting with GoDaddy, you can simply upload the file to your account and send us a link. For example, upload the file to the same directory as your wordpress site, and then the link should be yourdomain.com/thefile.sql

25. Blue Collar Todd
    Member
    Posted 7 months ago #

    My other problem, more immediate, is fixing the ".html" at the end of my url's. If someone searches google and it gives a link with that at the end, it comes up 404 error. If that is deleted ".html" then the page loads. Any easy scan/fix for that? Someone recommended a permalink plugin, but looks like it only does one at a time and in the WordPress dashboard. I need to fix the embedded links in posts and the search engine results, probably 1,000 links. Maybe a website or program that does it?

26. Brad Markle
    Member
    Posted 7 months ago #

    My initial follow question would be, why is Google indexing pages with a .html extension when their shouldn't be one?

    Do you have some sore of seo plugin, or do you recall setting this up?

27. Blue Collar Todd
    Member
    Posted 7 months ago #

    I have been trying various plugins to fix this. I may have used an SEO. But not to set it up. Should I delete any SEO related plugins even if they are inactive? How do I fix the search results on google?

28. Blue Collar Todd
    Member
    Posted 7 months ago #

    Just found this link for advice, but is way over my head.

    http://www.besthostratings.com/articles/remove-index.html

    But it deals exactly with my problem.

29. Brad Markle
    Member
    Posted 7 months ago #

    If someone searches google and it gives a link with that at the end, it comes up 404 error. If that is deleted ".html" then the page loads. Any easy scan/fix for that?

    Can you respond back with your domain name so that we can test to see how exactly it looks in Google Search Results?

    The previous link you gave I don't think hits 100% on the issue you're having, and seeing what the issue actually is within Google will help point you in the right direction.

30. Blue Collar Todd
    Member
    Posted 7 months ago #

    Here is a search from google for a post I know is there: Search words "lonely forest blue collar"

    http://www.google.com/search?rlz=1C1CHFX_enUS447US447&gcx=w&sourceid=chrome&ie=UTF-8&q=fix+google+.html+indexing#hl=en&rlz=1C1CHFX_enUS447US447&sa=X&ei=hMOuTsbXNqXXiAK2ieW1Cw&ved=0CBcQvwUoAQ&q=lonely+forest+blue+collar&spell=1&bav=on.2,or.r_gc.r_pw.,cf.osb&fp=19557f1f637173eb&biw=1280&bih=598

    First result comes up with and the error:

    http://bluecollarphilosophy.com/2011/03/we-sing-in-time-music-video-by-the-lonely-forest.html

    Delete the ".html" and it comes up just fine:

    http://bluecollarphilosophy.com/2011/03/we-sing-in-time-music-video-by-the-lonely-forest/

    And the domain by itself:

    http://bluecollarphilosophy.com/

Reply »

You must log in to post.