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"; ?> |
Latest Snippets
- Firefox 133 Tabs on Top – Update Nov 24 29th November 2024
- Exclude category from blog while adding them to sitemap.xml 16th January 2024
- What Router can I use with Onestream Broadband? 28th June 2023
- Disable buying – Woocommerce 25th April 2023
- Windows Desktop Wallpaper Background for OCD users with shelves 13th April 2023
- Featured Image Admin Thumb – Working Plugin (WordPress 6.2) 6th April 2023
- Create a gallery in a Posts page 3rd March 2023
- Clickable elements too close together – Solved 21st February 2023
- Best ChatGPT Prompts 24th January 2023
- Make Elementor Accordion Closed by Default 13th January 2023
LINKS