Home  >  Article  >  Backend Development  >  PHP code to backup mysql database

PHP code to backup mysql database

WBOY
WBOYOriginal
2016-07-25 08:45:40903browse
  1. $Database_name = 'somedb';
  2. $table = 'sometable';
  3. Define ('H', 'localhost'); define ('N', 'root') define ('P','password'); define ('T', $database_name);
  4. Mysql_connect (H, N, P) or die (mysql_error ()); mysql_select_db (T) or die (mysql_error ());
  5. function Escape($v){return mysql_real_escape_string($v);}
  6. Define('FILE', 'C:/Program Files/EasyPHP 2.0b1/www/'. $table .'/'. date ('d').'-'. date (' m').'-' . date ('Y').'.php');
  7. Define('FP', fopen(FILE,'w'));
  8. $aa = mysql_list_tables($database_name); while ($a = mysql_fetch_row($aa))
  9. {
  10. $bb = mysql_query ('SELECT * FROM'. $a[0].''); $tt = mysql_num_rows($bb); $nb = mysql_num_fields($bb);
  11. If($tt>0)
  12. {
  13. $p = 'INSERT INTO'. $a[0]. " VALUES ';
  14. $t = 0;
  15. while ($b = mysql_fetch_array($bb))
  16. {
  17. $ p .='(';
  18. For ($i=0;$i<$nb, $i++)
  19. {
  20. if ($i==0)
  21. {
  22. $p .= "'$b[$i]'";
  23. }
  24. else
  25. {
  26. $p .=' , ''. Escape($b[$ i]). ''';
  27. }
  28. }
  29. $t++;
  30. if ($t<$tt)
  31. {
  32. $ p .='),'." n ";
  33. }
  34. else
  35. {
  36. $ p .=');'." n";
  37. }
  38. }
  39. $p .= "nnn";
  40. fwrite(FP, $p);
  41. }
  42. }
  43. fclose(FP);
  44. ?>
复制代码

php, mysql


Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn