Back up mysql database with php code
- $ 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'. $ 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
