Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
- }
Add Comment
Please, Sign In to add comment