Backing up a wordpress blog

Anyone know how I backup a wordpress blog (that I have plugged into my own site)? I presume all the data is stored in the MySQL database on my site? How do I back that up? Thanks!

mysqldump?

You can do this through cPanel - Files>>Backup, then click on a Database name to download a copy. There's a Restore option on the same page.

OK thanks! And welcome back GfK.

OK, I'm still not clear on this. Perhaps I need to be more specific. I have the cpanel X thing on my domain so I can type www.greyaliengames.com/cpanel and I get a Cpanel X page with tons of options including File Manager and also a MySQLDatabases page which has a pphpMyAdmin function (includes exports but I'm not sure that's what I need). I was just hoping there was a simple file to download and keep a copy of...

I just went into my actual wordpress admin and did an export there to an xml file on my PC. Maybe that'll do...

The version of cPanel I have (11.15.0) is split into various sections, one of which is 'Files'. It has things like File Manager, FTP Session Control and stuff in it. That's where the 'Backup' option is.

When you go into Backup (NOT Backup Wizard!), you have a few options such as backup/restore your home directory, complete backup, database backup and Email Forwarders/Filters.

Under 'Databases' is a list of the databases currently set up on your site, one of which will be the one used by Wordpress.

Click on the database name and it will compress and download the file for you.

One thing to note is that if your wordpress database is greater than 2mb compressed then you may not be able to import it back via cPanel depending on your hosts PHP settings.

If it is larger than 2mb then use PHPMyAdmin to export it and then something like http://www.ozerov.de/bigdump.php to import it back.

If it's small then it'll be much easier via your cPanel.

*edit* unless you have root access to your hosting then mysqldump is the ticket :)

Exellent tips thanks guys!