RE: [cobalt-users] RAQ550 General Questions

["Leigh Jamgochian" <leigh@xxxxxxxxxxx>]

> -----Original Message-----
> From: cobalt-users-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-users-admin@xxxxxxxxxxxxxxx]On Behalf Of
> BSmith@xxxxxxxxxxx
> Sent: Friday, August 30, 2002 9:12 AM
> To: cobalt-users@xxxxxxxxxxxxxxx
> Subject: RE: [cobalt-users] RAQ550 General Questions
>
> http://www.mysqlfront.de
>
> They posted this a little while ago.  It is, by far, one of the BEST GUI
> apps for MySQL that I have seen.  It is free, works on Windows XX.  If you
> ever administered a database, you would be foolish if you don't use it.
> phpMyAdmin is also really good, but it is web based, and depending on
> traffic, could be a little slow.

Wouldn't this tool also be victim to network traffic?  Unless it's running
this on the server the commands still have to travel up the pipe and and the
results back down the pipe.  phpMyAdmin does send its interface down the
pipe however the relative bandwith hit should small for the benefit of
running on almost any platform.  Plus if your bandwith is hosed phpMyAdmin
will not work and you'll know it RIGHT away...

mySQLFront does have a LOT bit more features and functionality which make my
job a LOT easier and I'm going to use it but there is a security note.

With phpMyAdmin is that I can secure the pipe (SSL and HTTP Authentication)
and all MySQL users are limited to access to the database from localhost.
With this client you have to open up at least one user's access the database
from somewhere else and can potentially fall victim to password theft and
then you loose your database.  Make SURE you have good passwords (blank =
NOT GOOD) and if you can limit the users to connect only from certian hosts
(anybody with a dynamic IP address is going to have a tough time with this).
This will help avoid the simple script kiddie hacks out there.

I'm not trying to say don't try this tool just be careful.  I've just
downloaded it and I'm going to give it a shot because of a LOT of the
features that phpMyAdmin don't have.

In regards to Upgrading from a Raq4 to Rag550 I've just completed the work.
UGGG... My old Raq4 was dying because the fans stopped.  (The joys of not
visiting your server) and I was unable to do a bulk move.  I also had to
reassign the IP addresses (which you will have to do manually anyway the
migration tool doesn't support it)

I migrated each by creating a new site on the server and the users and then
copied the files from one to the other. It was a very tedious process as I
had to watch how hot my Raq4 got.  PHP and HTML files migrated fine however
its a fight with FrontPage extensions(don't move the _vti files or
directories and enable FP AFTER you copy).  This method should work for ASP
files.  I had 100+ sites and it took me about 4 days.

Leigh