Advertisement
AMONRA75

PHP - MYSQL BACKUP

Jun 28th, 2019
176
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.32 KB | None | 0 0
  1. <?php
  2.  
  3. $servername = "localhost";
  4. $username = "root";
  5. $password = "";
  6. $dbname = "binax";
  7.  
  8. $conn = mysqli_connect($servername, $username, $password, $dbname) or die("Connection failed: " . mysqli_connect_error());
  9. /* check connection */
  10. if (mysqli_connect_errno()) {
  11.     printf("Connect failed: %s\n", mysqli_connect_error());
  12.     exit();
  13. }
  14.  
  15.  
  16. $tables = array();
  17.  
  18. $result = mysqli_query($conn,"SHOW TABLES");
  19. while ($row = mysqli_fetch_row($result)) {
  20.     $tables[] = $row[0];
  21. }
  22.  
  23. $return = '';
  24.  
  25. foreach ($tables as $table) {
  26.     $result = mysqli_query($conn, "SELECT * FROM ".$table);
  27.     $num_fields = mysqli_num_fields($result);
  28.  
  29.     $return .= 'DROP TABLE '.$table.';';
  30.     $row2 = mysqli_fetch_row(mysqli_query($conn, 'SHOW CREATE TABLE '.$table));
  31.     $return .= "\n\n".$row2[1].";\n\n";
  32.  
  33.     for ($i=0; $i < $num_fields; $i++) {
  34.         while ($row = mysqli_fetch_row($result)) {
  35.             $return .= 'INSERT INTO '.$table.' VALUES(';
  36.             for ($j=0; $j < $num_fields; $j++) {
  37.                 $row[$j] = addslashes($row[$j]);
  38.                 if (isset($row[$j])) {
  39.                     $return .= '"'.$row[$j].'"';} else { $return .= '""';}
  40.                     if($j<$num_fields-1){ $return .= ','; }
  41.                 }
  42.                 $return .= ");\n";
  43.             }
  44.         }
  45.         $return .= "\n\n\n";
  46.    
  47. }
  48.  
  49.  
  50. $handle = fopen('backup/backup.sql', 'w+');
  51. fwrite($handle, $return);
  52. fclose($handle);
  53. echo "success";
  54.  
  55.  
  56. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement