Recover WordPress site

  • 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)

  • 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)

    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!

    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)

    $table_prefix = ‘wp_’

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