CREATE TABLE x LIKE y;

CREATE TABLE x LIKE other_db.y;

INSERT INTO x SELECT * FROM other_db.y;

#!/bin/bash

DBUSER=user
DBPASSWORD=pwd
DBSNAME=sourceDb
DBNAME=destinationDb
DBSERVER=db.example.com

fCreateTable=""
fInsertData=""
echo "Copying database ... (may take a while ...)"
DBCONN="-h ${DBSERVER} -u ${DBUSER} --password=${DBPASSWORD}"
echo "DROP DATABASE IF EXISTS ${DBNAME}" | mysql ${DBCONN}
echo "CREATE DATABASE ${DBNAME}" | mysql ${DBCONN}
for TABLE in `echo "SHOW TABLES" | mysql $DBCONN $DBSNAME | tail -n +2`; do
        createTable=`echo "SHOW CREATE TABLE ${TABLE}"|mysql -B -r $DBCONN $DBSNAME|tail -n +2|cut -f 2-`
        fCreateTable="${fCreateTable} ; ${createTable}"
        insertData="INSERT INTO ${DBNAME}.${TABLE} SELECT * FROM ${DBSNAME}.${TABLE}"
        fInsertData="${fInsertData} ; ${insertData}"
done;
echo "$fCreateTable ; $fInsertData" | mysql $DBCONN $DBNAME

echo "set foreign_key_checks = 0; $fCreateTable ; $fInsertData ; set foreign_key_checks = 1;" | mysql $DBCONN $DBNAME

CREATE TABLE t2 SELECT * FROM t1;

function cloneTable($table,$newTable){
global $admin;
$db_check = @mysql_select_db ( $table );
$getTables  =   $admin->query("SHOW TABLES");
$tables =   array();
while($row = mysql_fetch_row($getTables)){
    $tables[]   =   $row[0];
    }
$createTable    =   mysql_query("CREATE DATABASE `$newTable` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;") or die(mysql_error());
foreach($tables as $cTable){
    $db_check   =   @mysql_select_db ( $newTable );
    $create     =   $admin->query("CREATE TABLE $cTable LIKE ".$table.".".$cTable);
    if(!$create) {
        $error  =   true;
        }
    $insert     =   $admin->query("INSERT INTO $cTable SELECT * FROM ".$table.".".$cTable);
    }
return !isset($error) ? true : false;
}