Is there an editor or tool for this?

Directly editing fields

[Wlauzon]

We are setting up a new ecommerce site. Each product has about 30 fields that need to be set or edited. Not all of those fields are available via csv or other import. The UI for working on each item is a bit slow and clumsy.

So is there a way to, or a program that we can download the mySQL data (basically a backup file), edit the fields as needed, and then upload it back to update?

Or is this a bad way to go?

I know little about SQL databases - is there a better way to do this?

[ag_47]

hmm, how about phpMyAdmin? It's basically an open source UI for managing mySql, pretty easy to use. Most hosts have it available.

[Wlauzon]

Not really a user friendly interface for editing about 30 fields out of 350+.

It works, yes, but no better and maybe worse than using the regular program interface.

[Marcia]

You can set up Apache, MySQL and PHP on a home machine (Linux or Windows).

[topr8]

phpmyadmin can be used to create 'back up files' in various formats, you could then download the backup to your local machine and edit the file there, then reverse the process.

however it seems you need to design a decent backend for updating the data online, there are tools available that can build half decent backends, check out somewhere like hotscripts: php database tools.

[Receptional Andy]

There are various standalone software packages for editing SQL databases too - you'll find plenty searching for "MySQL GUI" and similar.