Page 1 of 1

Managing multiple PHP MySQL Connections

Posted: Fri Feb 05, 2010 3:29 am
by prema.php
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.

Re: Managing multiple PHP MySQL Connections

Posted: Fri Feb 05, 2010 1:54 pm
by tr0gd0rr
What is not working? Nothing in your code sticks out to me as wrong.

If your one user has access to both databases, you should be able to do your `CREATE TABLE ... LIKE` idea. If not, you could get the value of `SHOW CREATE TABLE ...`.