editing EE database with mysql GUI's

[stevehof]

It seems to me I read somewhere that it wasn't recommended to edit the EE database outside of EE's web based tools. I've been trying out EMS MySQL manager on my local PC’s EE MySQL database and it seems to work fine. I'd like to 'backup' my web site's EE database, drop it in my local PC’s MySQL server and fill in data in the photo text fields for my 400 images using the EMS GUI and then restore the edited database back to my live EE web site. Does anybody have any experience with this type of database editing approach with EE databases?

[pigasus]

I've done that using phpMyAdmin and it worked OK - except don't forget that your paths will not be the same for the web and PC versions. Also, while you're updating on your PC, unless you close your web site to visitors, your web database will be changing (new counts, possible feedback messages).

[stevehof]

Thanks for the input. I'd forgotton about the database changing while doing the editing on my PC. Oh well, I guess I can live with that....:^) It looks like I can restore a table using the MySQL GUI I'm experimenting with. Maybe I can do the edits on the photo text table and then restore only that table to a freshly backed up EE database...back to the drawing board....