[Zope] MySQL Admin Tool Recommendations

[Paul Zwarts]

Tim,

Is there anything wrong with just creating ZSQL methods that create
tables? Personally I create an admin folder with restricted access with
a subfolder call install_tables that houses all methods for building and
droping the tables you need. You can alse use these to create some admin
pages that will backup all tables to an archived set, then drop and
rebuild the active tables selected (the wonders of <dtml-in
"objectValues('ZSQL Methods')">).

There are a few Mysql tools but youre right. They all (at least the ones
I've found) suck.

Paul Zwarts

-----Original Message-----
From: zope-admin@zope.org [mailto:zope-admin@zope.org] On Behalf Of Tim
Owen
Sent: Tuesday, November 06, 2001 11:19 AM
To: zope@zope.org
Subject: [Zope] MySQL Admin Tool Recommendations

Anyone have a recommendation as to what the best Windows admin tool for
MySQL databases for use with Zope is?=A0 I looked at the Windows admin
tool that comes with MySQL but it does not create tables, etc.=A0 I also
looked at MySQLGUI and it looked weak as well.=A0 I would rather not =
have
to run MyPHPAdmin since I am running Zope not PHP.=A0 =A0I would be
interested in the same for Linux (SuSE 7.2).
=A0
Thanks in advance.
=A0