Brain Apperently Disabled on Sundays
This morning I saw a post from Vlad that there was a SIMPLE Security Update to WordPress(the engine under this blog), so I figured why not. I read the simple instructions which said make sure to backup both the content and the database before proceeding. So of course I went to do that, well the content was no problem, I just ftp’d the entire blog to my local hard drive. However then the moron in me kicked in and I could not for the life of me figure out how to backup the database. After an hour or so of clicking links and reading articles, I decided to throw caution to the wind and just do the update.
The update went fine and only took a few minutes, but now I will be up all night realizing I am not smart enough to backup a database that would most likely fit on a floppy disk.
If you would like to see me sleep again some day and you know how to backup a mySQL database from a wordpress blog admin page, I would love to hear.
Happy New Year,
HA
December 30th, 2007 at 9:00 pm
The control panel (cPanel) for my site has a backup option that allow backing up individual MySql databases. They just download a gzip file.
What’s your site’s control panel?
December 30th, 2007 at 11:12 pm
I beleive it is the standard word press control panel, it has lots of options, but not one I can find to do a backup.
December 31st, 2007 at 1:37 pm
You could install phpmyadmin, it provides a web interface to your mySql databases.
It is the included tool in most of the hosting packages I have used. Only takes a few minutes to install if it isn’t already available.