I had a WP blog about 3 years ago that was shut down, but before that happened I used a backup plugin to backup the database. It just gave me a .sql file zipped in a .gz. Is there any way to read the file without actually creating another blog and uploading it? The main thing I want to do is see the names of the categories.
Additionally, if I do create a new blog and attempt to restore the backup (I also saved the theme and all the settings/plugins so I assume it would be fairly simple to replicate the original site), how would I do that? Do I have to do it using the same backup plugin? Would it have backed up all the images, posts, pic galleries, etc? I've never had to restore one before so I'm not sure how it would work. I do remember there were around 150 separate pic galleries using that NextGen Gallery plugin, which took FOREVER to create.
Additionally, if I do create a new blog and attempt to restore the backup (I also saved the theme and all the settings/plugins so I assume it would be fairly simple to replicate the original site), how would I do that? Do I have to do it using the same backup plugin? Would it have backed up all the images, posts, pic galleries, etc? I've never had to restore one before so I'm not sure how it would work. I do remember there were around 150 separate pic galleries using that NextGen Gallery plugin, which took FOREVER to create.