Posted By

fackz on 10/26/10

Tagged

Versions (?)

Last Edited at 10/26/10 04:07am

Statistics

Viewed 1224 times

Favorited by 4 user(s)

Related snippets

PHP script to make a backup copy of a MySQL table

/ Published in: PHP

The script below connects to a MySQL database server on "localhost" using the login name "test" and password "123456" and then connects to the database "test". It then copies the table structure and data from the table "products" to a new table "products_bak". If the target table already exists the function returns false.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

<?php
 
mysql_connect('localhost', 'test', '123456');
mysql_select_db('test');
 
if(copy_table('products', 'products_bak')) {
    echo "success\n";
}
else {
    echo "failure\n";
}
 
function copy_table($from, $to) {
 
    if(table_exists($to)) {
        $success = false;
    }
    else {
        mysql_query("CREATE TABLE $to LIKE $from");
        mysql_query("INSERT INTO $to SELECT * FROM $from");
        $success = true;
    }
 
    return $success;
 
}
 
function table_exists($tablename, $database = false) {
 
    if(!$database) {
        $res = mysql_query("SELECT DATABASE()");
        $database = mysql_result($res, 0);
    }
 
    $res = mysql_query("
        SELECT COUNT(*) AS count
        FROM information_schema.tables
        WHERE table_schema = '$database'
        AND table_name = '$tablename'
    ");
 
    return mysql_result($res, 0) == 1;
}
 
 
?>