Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .