Managing multiple PHP MySQL Connections

prema.php · Joined: 05 Feb 2010 Posts: 2

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.

lostboy · Joined: 02 May 2004 Posts: 6033 Location: toronto, canada

I believe that the CREATE TABLE LIKE only works when the DBs are the on the same server, housed in the same mysql instance.

I would use the SHOW CREATE TABLE tableName syntax to retrieve the create table statement from the DB and run it in the other server[/code]

qforever · Joined: 01 Feb 2010 Posts: 4

Try to use