codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Drop, then Create, then Clone database

    22nd August 2014

    MySql

    mysql codehaven category

    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";
    ?>
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN