Re: How to connect Web database
| From: | Intruder | Date: | Sun, 06 Oct 2002 10:19:18 +0000 |
| Subject: | Re: How to connect Web database | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-118986@lists.php.net to get a copy of this message | ||
You have to use mysqldump utility to make script, then you can put it into your
PHP script and run that script:
<?php
$sql = "<PRODUCED SCRIPT BODY GOES HERE>";
mysql_query($sql);
?>
or just dump your database directly to remote server by running mysqldump with
parameters Host and some other. The only difficulty could be, that remote
provider could reject all emote connections :((
the third way is to place PHP script on remote mashine and to connect to your
local MySQL server and just make some SELECT-INSERT. Here you can have the same
problem as in previous: proveder can reject all connection aoutside their box
:(((