Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have local Wordpress database that got corrupt as a result of an abrupt power outage (I wasn't even editing it!).

Since the system I am dealing with is pretty static (and old), I just want to restore that database file (or collection of files) from a nightly backup.

But I don't know which files I should be restoring. The WordPress blog in question is installed under a local user account in an old Linux server (FC4).

I checked the wp-content directory, but apparently this is not where the content is:

~/public_html/wordpress/wp-content> ls -l
total 24
-rw-r--r--  1 ww4s ww4s   32 Nov 18  2005 index.php
drwxr-xr-x  3 ww4s ww4s 4096 Jun  2  2006 plugins
drwxr-xr-x  4 ww4s ww4s 4096 Mar 10  2006 themes

Any idea which file(s) I should be restoring and what their path is?

share|improve this question
add comment

1 Answer

up vote 5 down vote accepted

WordPress is almost certainly using a MySQL database for storing its content, and those are usually stored elsewhere on the system, often /var/lib/mysql/some_db_name. Open up your wp-config.php file and start looking at your MySQL settings. These should help you figure out your environment and where to look next. You can see a sample wp-config.php file here.

share|improve this answer
    
Indeed, my version of WordPress is using MySQL, and the databases are stored in directories /var/lib/mysql - a path pointed to by the variable datadir in /etc/my.conf (one directory per database). Thanks + 1 + Accepting. –  WinWin Jun 17 '11 at 22:49
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.