From: Ed Carp
Date: March 24 1999 5:34pm
Subject: Re: Managing Unix mySQL database from PC?
List-Archive: http://lists.mysql.com/myodbc/96
Message-Id: <001901be761c$8bbaf580$74c9a8c0@traveler.airmail.net>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>I am building a web site using mySQL on a Sun UltraSparc server
>managed by a commercial hosting provider.  My question is:
>
>    What is the best strategy (or what are my options) for managing
>    this database from my (local) PC?
>
>I'm new to this, but I imagine my options might include:
>
>A)  Do everything on the server.  Build a secure management
>    interface to allow us to perform management operations
>    from a web browser.
>
>B)  Arrange to export/import tables, download/upload to/from PC,
>    manipulate data locally in, e.g., MicroSoft Access.
>
>C)  Arrange for flexible remote access to the database on the
>    server, e.g., by having MicroSoft Access talk to the remote
>    database via ODBC.  (I have no idea if this is possible.)


(C) is your best bet, but I'd advise against using Access - write code in
Visual Basic to manipulate the server.  Most database operations in MySQL
can be done by throwing SQL at the server.