php代碼備份mysql資料庫

$Database_name = 'somedb'; $table = 'sometable'; Define ('H', 'localhost'); define ('N', 'root') define ('P','password'); define ('T', $database_name); Mysql_connect (H, N, P) or die (mysql_error ()); mysql_select_db (T) or die (mysql_error ()); function Escape($v){return mysql_real_escape_string($v);} Define('FILE', 'C:/Program Files/EasyPHP 2.0b1/www/'. $table .'/'. date ('d').'-'. date (' m').'-' . date ('Y').'.php'); Define('FP', fopen(FILE,'w')); $aa = mysql_list_tables($database_name); while ($a = mysql_fetch_row($aa)) { $bb = mysql_query ('SELECT * FROM'. $a[0].''); $tt = mysql_num_rows($bb); $nb = mysql_num_fields($bb); If($tt>0) { $p = 'INSERT INTO'. $a[0]. " VALUES '; $t = 0; while ($b = mysql_fetch_array($bb)) { $ p .='('; For ($i=0;$i<$nb, $i++) { if ($i==0) { $p .= "'$b[$i]'"; } else { $p .=' , ''. Escape($b[$ i]). '''; } } $t++; if ($t<$tt) { $ p .='),'." n "; } else { $ p .=');'." n"; } } $p .= "nnn"; fwrite(FP, $p); } } fclose(FP); ?> 複製代碼

php, mysql

