首页 / PHP / 备份mysql数据的php代码

备份mysql数据的php代码

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了备份mysql数据的php代码，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含4161字，纯文字阅读大概需要6分钟。

内容图文

  1. <?php
  3. #####################
  4. //CONFIGURATIONS
  5. #####################
  6. // Define the name of the backup directory
  7. define('BACKUP_DIR', './myBackups' ) ;
  8. // Define Database Credentials
  9. define('HOST', 'localhost' ) ;
  10. define('USER', 'testd!b' ) ;
  11. define('PASSWORD', 'k^$2y4n9@#VV' ) ;
  12. define('DB_NAME', 'test123' ) ;
  13. /*
  14. Define the filename for the sql file
  15. If you plan to upload the file to Amazon's S3 service , use only lower-case letters
  16. */
  17. $fileName = 'mysqlbackup--' . date('d-m-Y') . '@'.date('h.i.s').'.sql' ;
  18. // Set execution time limit
  19. if(function_exists('max_execution_time')) {
  20. if( ini_get('max_execution_time') > 0 ) set_time_limit(0) ;
  21. }
  23. ###########################
  25. //END OF CONFIGURATIONS
  27. ###########################
  29. // Check if directory is already created and has the proper permissions
  30. if (!file_exists(BACKUP_DIR)) mkdir(BACKUP_DIR , 0700) ;
  31. if (!is_writable(BACKUP_DIR)) chmod(BACKUP_DIR , 0700) ;
  33. // Create an ".htaccess" file , it will restrict direct accss to the backup-directory .
  34. $content = 'deny from all' ;
  35. $file = new SplFileObject(BACKUP_DIR . '/.htaccess', "w") ;
  36. $file->fwrite($content) ;
  38. $mysqli = new mysqli(HOST , USER , PASSWORD , DB_NAME) ;
  39. if (mysqli_connect_errno())
  40. {
  41. printf("Connect failed: %s", mysqli_connect_error());
  42. exit();
  43. }
  44. // Introduction information
  45. $return .= "--\n";
  46. $return .= "-- A Mysql Backup System \n";
  47. $return .= "--\n";
  48. $return .= '-- Export created: ' . date("Y/m/d") . ' on ' . date("h:i") . "\n\n\n";
  49. $return = "--\n";
  50. $return .= "-- Database : " . DB_NAME . "\n";
  51. $return .= "--\n";
  52. $return .= "-- --------------------------------------------------\n";
  53. $return .= "-- ---------------------------------------------------\n";
  54. $return .= 'SET AUTOCOMMIT = 0 ;' ."\n" ;
  55. $return .= 'SET FOREIGN_KEY_CHECKS=0 ;' ."\n" ;
  56. $tables = array() ;
  57. // Exploring what tables this database has
  58. $result = $mysqli->query('SHOW TABLES' ) ;
  59. // Cycle through "$result" and put content into an array
  60. while ($row = $result->fetch_row())
  61. {
  62. $tables[] = $row[0] ;
  63. }
  64. // Cycle through each table
  65. foreach($tables as $table)
  66. {
  67. // Get content of each table
  68. $result = $mysqli->query('SELECT * FROM '. $table) ;
  69. // Get number of fields (columns) of each table
  70. $num_fields = $mysqli->field_count ;
  71. // Add table information
  72. $return .= "--\n" ;
  73. $return .= '-- Tabel structure for table `' . $table . '`' . "\n" ;
  74. $return .= "--\n" ;
  75. $return.= 'DROP TABLE IF EXISTS `'.$table.'`;' . "\n" ;
  76. // Get the table-shema
  77. $shema = $mysqli->query('SHOW CREATE TABLE '.$table) ;
  78. // Extract table shema
  79. $tableshema = $shema->fetch_row() ;
  80. // Append table-shema into code
  81. $return.= $tableshema[1].";" . "\n\n" ;
  82. // Cycle through each table-row
  83. while($rowdata = $result->fetch_row())
  84. {
  85. // Prepare code that will insert data into table
  86. $return .= 'INSERT INTO `'.$table .'` VALUES ( ' ;
  87. // Extract data of each row
  88. for($i=0; $i<$num_fields; $i++)
  89. {
  90. $return .= '"'.$rowdata[$i] . "\"," ;
  91. }
  92. // Let's remove the last comma
  93. $return = substr("$return", 0, -1) ;
  94. $return .= ");" ."\n" ;
  95. }
  96. $return .= "\n\n" ;
  97. }
  98. // Close the connection
  99. $mysqli->close() ;
  100. $return .= 'SET FOREIGN_KEY_CHECKS = 1 ; ' . "\n" ;
  101. $return .= 'COMMIT ; ' . "\n" ;
  102. $return .= 'SET AUTOCOMMIT = 1 ; ' . "\n" ;
  103. //$file = file_put_contents($fileName , $return) ;
  104. $zip = new ZipArchive() ;
  105. $resOpen = $zip->open(BACKUP_DIR . '/' .$fileName.".zip" , ZIPARCHIVE::CREATE) ;
  106. if( $resOpen ){
  107. $zip->addFromString( $fileName , "$return" ) ;
  108. }
  109. $zip->close() ;
  110. $fileSize = get_file_size_unit(filesize(BACKUP_DIR . "/". $fileName . '.zip')) ;
  111. $message = <<<msg

  112. BACKUP completed ,


  113. the archive has the name of : $fileName and it's file-size is : $fileSize .
  114. This zip archive can't be accessed via a web browser , as it's stored into a protected directory .
  115. It's highly recomended to transfer this backup to another filesystem , use your favorite FTP client to download the archieve .
  116. msg;
  117. echo $message ;
  119. // Function to append proper Unit after file-size .
  120. function get_file_size_unit($file_size){
  121. switch (true) {
  122. case ($file_size/1024 < 1) :
  123. return intval($file_size ) ." Bytes" ;
  124. break;
  125. case ($file_size/1024 >= 1 && $file_size/(1024*1024) < 1) :
  126. return intval($file_size/1024) ." KB" ;
  127. break;
  128. default:
  129. return intval($file_size/(1024*1024)) ." MB" ;
  130. }
  131. }

mysql, php

内容总结

以上是互联网集市为您收集整理的备份mysql数据的php代码全部内容，希望文章能够帮你解决备份mysql数据的php代码所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/164748.html

来源：【匿名】