How to maintain a remote database?

From: Martin (martinvalley_at_comcast.net)
Date: 01/30/05 

Date: Sun, 30 Jan 2005 14:16:00 -0700

Newbie question:

What's the "proper" way for me as a site administrator to add and
delete records in a MySQL database?

I'm developing a web site that will be using PHP and MySQL. I'm doing
the development work on my own computer running IIS with, of course,
PHP and MySQL installed. When the site is operational (at a hosting
site yet to be determined), I will need to periodically (every few
days) add and delete records in the database. The users will be
interacting with these records via a couple of pages such that one or
two fields in a record will be changed (they will not be
adding/deleting anything).

While it's on my own computer, I can add/delete records just using the
MySQL command line interface. I won't be able to do that once it's
installed on the hosting site will I? Or, even if that's possible,
should I do it that way?

It would seem to me that I should create some pages for my exclusive
use that would allow me to maintain the db - yes?

Like I said, what's the proper way?

Thanks for any guidance.

Relevant Pages

  • Re: Fetch 6 records from a table randomly
    ... critical details (e.g. what sort of table? ... "I have a table 'documents' stored in a MySQL database that I'm accessing ... I haven't been able to find a function in Ruby to pick a random element. ...
    (comp.lang.ruby)
  • Re: sarge + postfix + mysql
    ... >So when postfix/courier is doing a mysql database lookup, ... >'vmail' that is only allowed to log in from localhost and has no ... >permissions for accessing the database 'provider'. ...
    (Debian-User)
  • Re: How to maintain a remote database?
    ... > delete records in a MySQL database? ... > I'm developing a web site that will be using PHP and MySQL. ... > installed on the hosting site will I? ...
    (comp.lang.php)
  • RE: CGI::Session
    ... > some hashes in a MySQL database, ... > other visitor preferences like the font style, colors, font ... > in a MySQL record than the session ID? ... transmitted without the written permission of the copyright owner. ...
    (perl.beginners)
  • Re: sarge + postfix + mysql
    ... If you are using postfix 2.2.x the sintax of the .cf files may be different. ... > So when postfix/courier is doing a mysql database lookup, ... > permissions for accessing the database 'provider'. ...
    (Debian-User)