Build Your Own Business Website header image

Community Library Website – Part 10b – Backup the Database Using phpMyAdmin

Difficulty Level -

Whoops, you've found some premium content!

Watch the opening clip of this video to preview it,
the full video is available to paid members.

This is the tenth in a series of live lessons on using WordPress and Thesis as a Content Management System (CMS). We are preparing to import existing data into the database so it is crucial to have a system in place for restoring the database to a pre-import condition. In this lesson we make some final adjustments to the site and then backup the database using phpMyAdmin. This is a simple solution to save your database and retrieve it again in case of errors while importing the data..

Video Transcript

That’s because we’re going to test this and we are going to fail at it and then we’re going to have to test it again and so on and so forth. Now that’s how to do it using plugin buddy but what I really want to show you how to do is how to do it using just straight phpMyAdmin. So we’re going to refresh this, now you can see all that stuff is there.

Okay so what I want to do then is I want to get a couple of things set up correctly before we back this up again and then take it from the top. We’re going to go down to custom post types and we’re going to fix the custom post type… manage post types. And what we’re going to do here is this section called media, we’re just going to… I think that’s just a recipe for disaster. So we’re just going to get rid of that and we’re going to call it catalog items, label catalog item, singular label… oh pardon me. That is the plural label items, singular label is catalog item and we’re going to save this custom post type. And then what we need to do is we need to make sure that we go fix our taxonomies because we have these custom taxonomies that are still linked to a post type media and we don’t want to do the post type media.

So we are going to select catalog items and then we’re going to move a location to catalog items. This is just attaching the custom taxonomy to the custom post type. Okay, we’ll do audience and we’ll do review… I mean, I’m sorry… authors. Okay so now everything is properly attached to the catalog items and then we need to go back and do that Verve meta boxes thing again. So I didn’t save… I didn’t….I made this change before I killed the database so I’m just going to get rid of this and we’re going to recreate it as a select and circulation time. Add the field and it’s going to be 7 days, 14 days, and custom… okay. Oh, I needed to save that. Okay, 7 days, 14 days, library use only, and custom and hit enter. That saves it.

Okay and then I want this catalog item to be attached to this catalog items post type. So we’re going to update the box then we’re going to come over briefly and take a look at our catalog items. I’d originally created 2. Oh okay, I guess I didn’t originally create 2. So add a new item and you can see over here now we have media type that shows up locations that show up. Topics, audience, and authors… and then over here, we have barcode, call number, ISBN, publication year, circulation time okay?

So this is all properly set up now and now what we’re going to do is come over here to Bluehost and we’re going to refresh this. Because all that information is now saved inside this database so what we’re going to do is we’re going to export this database. And we are going to export all of it and we’ll export it as gzipped and say “go”. Okay so now that’s downloaded to my website… I mean, sorry… downloaded from the site to my computer. So now, this has the whole database here on my computer and when I need to come back and back this up or restore it back to this condition, I can do so.

0 Comments… add one

Save $200 on Membership Now!

Start learning today for as little as
$0.82 PER DAY!
Subscription Options
0 comments… add one

Leave a Comment