Managing multiple PHP MySQL Connections

[jspodisus]

I m trying to create a new table on server B as like a table on server A in php script.

The steps I did are,

1. Using mysql_connect() and mysql_select_db() I established connection on Server A & B with 2 different variable sets, say variable $db1 holds the db of Server A and variable $db2 holds the db of Server B.

 

2. Tables are list from both the DBs

 

3. Needed to create missing tables on Server B [ie., copy missed tables with rows from server A to Server B]. Here, it is struggling................

 

How to create or copy a specific table from one server to another server or IP in PHP ???

 

 

Here is my code:

<?php

#Staging

$hostname='localhost';

$un= 'admin';

$pwd='******';

$db='instglive';

$link=mysql_connect($hostname, $un, $pwd);

if(!$link)

die('Could not connect: ' . mysql_error());

 

if(!mysql_select_db($db,$link))

die('Could not link db: ' . mysql_error());

 

 

#Live

$hostname1='222.666.73.91';

$un1= 'test';

$pwd1='*******';

$db1='testdb';

$link1=mysql_connect($hostname1, $un1, $pwd1);

if(!$link1)

die('Could not connect: ' . mysql_error());

 

if(!mysql_select_db($db1,$link1))

die('Could not link db: ' . mysql_error());

 

 

$d="CREATE TABLE ".$db1.".".student." LIKE ".$db.".".student";

if(!mysql_query($d)) echo mysql_error();

 

?>

 

I need to work out the create table query on instglive db...

Can anybody help??????

Its urgent.

 

Thanks in advance.