1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 |
<?php $source_db='maindatabase'; $target_db='newdatabase'; $server='localhost'; $user='root'; $password=''; mysql_connect($server,$user,$password); mysql_select_db($source_db); mysql_query("drop database $target_db"); mysql_query("create database $target_db"); // Get names of all tables in source database $result=mysql_query("show tables"); while($row=mysql_fetch_array($result)){ $name=$row[0]; $this_result=mysql_query("show create table $name"); $this_row=mysql_fetch_array($this_result); $tables[]=array('name'=>$name,'query'=>$this_row[1]); } // Connect target database to create and populate tables mysql_select_db($target_db); $total=count($tables); for($i=0;$i < $total;$i++){ $name=$tables[$i]['name']; $q=$tables[$i]['query']; mysql_query($q); mysql_query("insert into $name select * from $source_db.$name"); } echo "Done"; ?> |
