copy table in another database mysql code example
Example: AUTO TRANSFER OF DATA FROM SYBASE TABLE TO PHPMYSQL TABLE
<?php
include 'config.php';
include 'opendb.php';
$tableName = 'mypet';
$backupFile = 'mypet.sql';
$query = "LOAD DATA INFILE 'backupFile' INTO TABLE $tableName";
$result = mysql_query($query);
include 'closedb.php';
?>