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.

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]

_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google

Try to use



and



queries. Seems it's what you need...