Hi,
There are two ways to administer your hosted DB:
- You can telnet (if your provider offers telnet accounts) and execute command-line
instructions in mySQL. Obviously you will need some SQL skills and a look at the
manual will be required to get yourself acquainted with the system
- There is a great utility called phpMyAdmin which is a Intranet-like interface to
mySQL databases. It is written in PHP so PHP 3.0.sthg must be running on your Web site
- ask your provider. You just need to change connection information - your provider
will give you the user name, password and DB name to use.
If you take a look at www.phpbuilder.net you should be able to find links to download
the program (it's free). I believe it should fulfil your needs.
Note that phpMyAdmin should be installed in a password-protected directory otherwise
anyone knowing the URL could mess with your data. On a *NIX platform with Apache
server it's easy.
Also, if you know PHP you can develop your own scripts to easily interface with the DB
to run queries, display data or feed the DB with raw files.
In summary you can do nearly anything with mySQL even if your Web site is hosted -
that's something I do every day. The restriction is that most of the time you have
only one user logon and can't create users or manage security options.
Of course it is better to know some SQL and be experienced with DB design to take
advantage of mySQL. Many tutorials are available. When your provider sets up the DB,
it's up to you to decide what you're going to put into it. They won't create tables
etc. for you, you must have an idea of what you want to do with your DB.
Hope this answers any doubts you might have. Let us know if you have more specific
questions.
Regards,
--------------------------------
Hello,
My associate wants me to setup a MySQL database which will be hosted by his
ISP. Unfortunately, they have no one (the ISP) that I can give me specific
instructions on setting up the database. They know how to create it, but
can tell me how to get our data/tables into it.
I was hoping that I could get some advise on getting the data/tables into
the database from our end. Do we Telnet into the database? Any help would
be greatly appreciated.
Lee Jenkins
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
