Monday, January 24, 2011

How to Find Your WordPress Database

I was looking for the WordPress
database today. Looks like it is
in this file here in the topmost
folder for WordPress:

wp-config.php

Once you get into this file, you
can find the following information:

  • name of the database
  • username for the database
  • password for the database
  • host for the database

I'm far from being an expert on
WordPress. However, it seems to
me that the host will either be
a URL or an IP address.

I suspect that once you have the
username and password, you can
log into the database in some
manner or other. However, I
would imagine that access is
limited to logins coming from
certain IP addresses.

Once you are logged in, you can
access the database by name.

This is all speculation on my
part. I've not tried any of this
yet.

Here's where I've written about
connecting to and disconnecting
from a MySQL database:

MySQL --- Getting Started

Since WordPress stores its data
in a MySQL database, it seems
that you could in theory connect
to the database in order to back
it up.

Of course, this is pure theory.
In actual practice, hosting companies
probably have severe restrictions on such
things because they do not want to give
access to databases to the outside world.
That's my conjecture at this point.

Ed Abbott

Tuesday, January 18, 2011

Backup WordPress

Here's a link that describes
how to backup wordpress:

How to back up your
WordPress blog in 60 seconds


Apparently Wordpress has some
kind of export function. I think
this may be a plugin but I'm not
sure. I'm learning as I write.

In the above link, someone left
a comment saying that you are
better off using Cpanel for backups.
Does Cpanel backup both the database
and the other content? Again, I'm
not sure.

Here's a Wordpress plugin that claims
it can be used to do complete backups
of both the database and the other
content:

BackUpWordPress

Here's someone who says there are 2 sides
to a WordPress backup:

  • code side
  • database side

Here's where he mentions
the 2 sides:

Code side and database side

This makes sense. Your blog
writings probably go into a
database. The templates are
probably code. You would need
to backup both sides.

It seems that there are 2 sides
to everything: a front side and
a back side; a inside and an outside.

WordPress seems to be no different.
It has 2 sides as well. It has a code
side and a data side.

Ed Abbott