advanced code snippet search

Posted By

fackz on 10/26/10


Tagged

mysql table backup copy


Versions (?)

Who likes this?

6 people have marked this snippet as a favorite

fackz
luman
ArbaouiMehdi
pytheas
thomas-h
Priestd09


PHP script to make a backup copy of a MySQL table

 / Published in: PHP
 

URL: http://www.electrictoolbox.com/php-script-backup-copy-mysql-table/

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 
  1. <?php
  2.  
  3. mysql_connect('localhost', 'test', '123456');
  4. mysql_select_db('test');
  5.  
  6. if(copy_table('products', 'products_bak')) {
  7.     echo "success\n";
  8. }
  9. else {
  10.     echo "failure\n";
  11. }
  12.  
  13. function copy_table($from, $to) {
  14.  
  15.     if(table_exists($to)) {
  16.         $success = false;
  17.     }
  18.     else {
  19.         mysql_query("CREATE TABLE $to LIKE $from");
  20.         mysql_query("INSERT INTO $to SELECT * FROM $from");
  21.         $success = true;
  22.     }
  23.  
  24.     return $success;
  25.  
  26. }
  27.  
  28. function table_exists($tablename, $database = false) {
  29.  
  30.     if(!$database) {
  31.         $res = mysql_query("SELECT DATABASE()");
  32.         $database = mysql_result($res, 0);
  33.     }
  34.  
  35.     $res = mysql_query("
  36.         SELECT COUNT(*) AS count
  37.         FROM information_schema.tables
  38.         WHERE table_schema = '$database'
  39.         AND table_name = '$tablename'
  40.     ");
  41.  
  42.     return mysql_result($res, 0) == 1;
  43. }
  44.  
  45.  
  46. ?>

Report this snippet  

You need to login to post a comment.