How to restore an SQL backup?

o hai guyz

New member
Jan 15, 2010
917
8
0
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.
 


You can open in MySQL Workbench - MySQL Workbench 5.2.34

or HeidiSQL http://www.heidisql.com

you can also do it via text editor, but if the file is large, it's better to just use a tool like those above.

If you have a local server running phpMyAdmin, you can also import the DB to look at it, and maybe even connect it to a WP installation