transfert entre 2 BdD local à internet => besoin d'aide

transfert entre 2 BdD local à internet => besoin d'aide - PHP - Programmation

Marsh Posté le 22-01-2006 à 23:04:30    

Voici mon code que j'execute à partir du serveur local easy php
 

Citation :

$link1 = mysql_pconnect("localhost", "root","" );
$link2 = mysql_pconnect("sql.xxxxxxxx.xx", "logininternet","passinternet" );
 
mysql_select_db($db1 , $link1);
mysql_select_db($db2, $link2);  
 
$result1= mysql_query($query1, $link1);  
$result2= mysql_query($query2, $link2);
 
$result1 = mysql_query("SELECT * FROM moteur'" );
$num_rows = mysql_num_rows($result1);
 
if($result1) {
while($row = mysql_fetch_array($result1)) {
 
$categorie = $row["categorie"];
$match = $row["match"];
echo  $row["url"];
print("<br>" );
 
$result2 = mysql_query("INSERT INTO `transfert` (`categorie`) VALUES ('$categorie')" );
}
}
mysql_close($link1);
mysql_close($link2);


 
...
et voici les erreurs renvoyées :
 

Citation :

Warning: mysql_pconnect(): Can't connect to MySQL server on 'sql.xxxxxxxx.xx' (10061) in d:\program files\easyphp1-8\www\matrice\transfert.php on line 7
 
Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 10
 
Notice: Undefined variable: query1 in d:\program files\easyphp1-8\www\matrice\transfert.php on line 12
 
Notice: Undefined variable: query2 in d:\program files\easyphp1-8\www\matrice\transfert.php on line 13
 
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 13
 
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 16
 
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in d:\program files\easyphp1-8\www\matrice\transfert.php on line 33


 
et voici ma réaction...
 :fou:  :heink:  :pt1cable:  :pt1cable:


Message édité par erwan83 le 22-01-2006 à 23:08:18

---------------
http://www.ypikay.com
Reply

Marsh Posté le 22-01-2006 à 23:04:30   

Reply

Marsh Posté le 22-01-2006 à 23:13:37    

Rare sont les hébergeurs qui permettent les connexions SQL externes ceci dit, tu as pensé à vérifier ce détail avant de criser ? :D

Reply

Marsh Posté le 23-01-2006 à 01:32:36    

ben heu....
non...  
tant pis vive le copier coller !


---------------
http://www.ypikay.com
Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed