Help With Schema for Wordpress Plugin

[mjtaylor]

Here's hoping my WP gurus can help me again ....

Does anyone here use the SchemaForWordpress plugin? I am trying to install it on my own blog (http://schemaforwordpress.com/installation/)

I have the plugin installed and activated; however, it requires that I upload a file I am at sea on getting the /schema-data/wp_sfwp.sql.zip file in the right place. In MySQL admin section there is a place to import files. Is that where I should do it? Or in the plugin settings there is an Import Schema for Wordpress button.

Any idea? It makes me nervous to import a file directly into MySQL ... has anyone else done this?

Thanks!

[SteveGerencser]

Yup, .sql.zip is an upload straight in to the database to add new tables that are needed for the plugin to work..

And yes, direct import in to sql always makes me nervous too.. Make sure that you have a solid backup before doing it 'just in case'.

[Refiner]

Steve is correct on this one, and I also recommend backing up your database before any modifications to your wordpress that require MySQL schema uploads.

I have run many of these, so I am not nervous about running updates. With a site backed up prior to any update, I know I can restore it to the last working state.

[mjtaylor]

Why do I hate doing backups?

Thank you both! Think I will go back up and try this ... eek, eek, eek, ick.

[deepsand]

I've never had any mentionable problems with back-ups; it's restores which have been problematic at times.