Recover WordPress site

  • RonaldBrink

    (@ronaldbrink)


    9 years, 11 months ago

    The computer of a friend of me crashed, and guess what? No backups!
    She wants me to recover her wordpress site which she locally was building using WebMatrix and WordPress. The only things I have been able to get from her harddisk are :
    1) The website itself which resided under windows\…\users\…\websites
    2) The mySql database : wordpress235, in her case.
    I made copies of the above and was able to recover the site and database under my own WebMatrix instance under a newly created WordPress site. Every thing seemed to be OK, apart from one major aspect : I can’t see neither her posts nor pages she build so far. In my opinion they should be in the wp_posts table, but when I try to access this table through mySql commandline I get the error that the table does not exists.
    Can anyone be of help?
    Regards, Ronald Brink

Viewing 4 replies - 1 through 4 (of 4 total)
  • Robey Lawrence

    (@robey)

    9 years, 11 months ago

    i’m not familiar with Webmatrix, but can you view the database in PHPmyAdmin and see the tables? perhaps the wordpress site is using an alternate table prefix. ie. wp_xxxxposts . and when the site has been recovered, it is not looking at the correct tables anymore?

    Thread Starter RonaldBrink

    (@ronaldbrink)

    9 years, 11 months ago

    Well, I can see the database (wordpress235) through the mySql commandline. When I there request for SHOW tables I do see all the wp_… tables, however when doing a SELECT * FROM wp_posts I’m getting the error (1146) table does not exists. Also on the windows file system I do see the wp_posts.frm file within the database within the mySQL data storage. Meanwhile I found out another weird thing, when copy the wp_posts.frm to another wordpressxxx database, I would expect that nothing will be showing up there either, but to my amazing then still the content of the wordpressxxx.wp_posts shows up there. I’m quite lost!

    Robey Lawrence

    (@robey)

    9 years, 11 months ago

    open the wp-config.php in a text editor like notepad (do not use Word). and find the line “$table_prefix”, what does it =?

    this will tell you the table prefix.

    Thread Starter RonaldBrink

    (@ronaldbrink)

    9 years, 11 months ago

    $table_prefix = ‘wp_’

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Recover WordPress site’ is closed to new replies.