Not quite that easy, I'm afraid. Firstly, I think you misunderstand the
meaning of "localhost". "localhost" refers to the computer to which a
particular software (usually a server software) is running on. Or have I
misunderstood you and you are running the MySQL server on one PC and the Web
server on another? and, Yes, MySQL data & php scripts don't usually reside
in the same directory.
Secondly, you will need to ensure your ISP supports MySQL and that they have
provided you with a MySQL account for you to use. Also note that you may
not be given a lot of freedom with the user account(s) that they set up for
you. You may have to modify your PHP scripts to suit the accounts your ISP
provides you with, especially the connection functions.
Just because you can't find a MySQL directory on your ISP's server, doesn't
mean to say it doesn't exist. It may mean you don't have the rights to see
it let alone access it and I'm talking about direct access. You can still
access the data indirectly through the mysql prompt or the mysql executable
commands. Therefore, if you have created and filled your tables with data
locally, you may be able to ask your ISP to copy the files into the correct
place and set the correct permissions for you, after you ftping them across
to the ISP server.
If they won't, you'll then have to export the data into a text delimited
file, ftp them across and then import the file. This is if they allow you
permission to import. If not, you then have the hard way, which is by using
php scripts or through the mysql prompt, or find yourself another ISP.
Also note, you may have to learn a little about unix based machines in order
to do this if you don't know already. I don't know what IPS's OS is but it
is most likely to be unix based as most of the world's web servers are unix
based.
----- Original Message -----
From: "Marco Bleeker" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 23:38
Subject: domain vs localhost
> Newby speaking here; I've just managed to get PHP and MySQL working, now
> creating my first database. When I do that off-line ('localhost'), the
data
> are entered in a MySQL subdirectory \MySQL\data. Not on a localhost
> subdirectory (where the php script is running). But I don't see a MySQL
> subdirectory with my hosting ISP. I would like to create and fill a
> database off-line, on my localhost, and then FTP the whole thing to my
> hosting ISP and make it accessable from my domain (www.ecocam.com). Any
> pointers? (localhost machine = Win98SE)
>
> Thanks, marco
> |
> | Marco Bleeker, Amsterdam
> | [EMAIL PROTECTED]
> | http://www.euronet.nl/users/mbleeker/
> |
> | Attachments only after prior notice please.
> | Don't put me on any kind of mailing list.
> |
> | I am now receiving the Snowhite virus 4x a day
> | - some of you must be infected, please check !
> | (No, you did not get it from me, I use Eudora)
> | __@
> | _`\<,_
> |__(*)/ (*)________________Ah, op DIE fiets !
>
>
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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