Use php to back up the source code of the mysql database. Remove the front line number when using the application.
- $ Host = "localhost ";
- $ User = "root ";
- $ Password = "";
- $ Dbname = "";
- Mysql_connect ($ host, $ user, $ password );
- Mysql_select_db ($ dbname );
- $ Mysql = "set charset utf8; rn ";
- $ Q1 = mysql_query ("show tables ");
- While ($ t = mysql_fetch_array ($ q1 )){
- $ Table = $ t [0];
- $ Q2 = mysql_query ("show create table '$ table '");
- $ SQL = mysql_fetch_array ($ q2 );
- $ Mysql. = $ SQL ['create table']. "; rnrn ";
- $ Q3 = mysql_query ("select * from '$ table '");
- While ($ data = mysql_fetch_assoc ($ q3 )){
- $ Keys = array_keys ($ data );
- $ Keys = array_map ('addslashes', $ keys );
- $ Keys = join ('','', $ keys );
- $ Keys = "'". $ keys ."'";
- $ Vals = array_values ($ data );
- $ Vals = array_map ('addslashes', $ vals );
- $ Vals = join ("','", $ vals );
- $ Vals = "'". $ vals ."'";
- $ Mysql. = "insert into '$ table' ($ keys) values ($ vals); rn ";
- }
- $ Mysql. = "rn ";
- }
- $ Filename = date ('ymj '). ". SQL ";
- $ Fp = fopen ($ filename, 'w ');
- Fputs ($ fp, $ mysql );
- Fclose ($ fp );
- Echo "the data is backed up successfully and the backup file is generated". $ filename ."";