'localhost','db_user'=>'root','db_pwd'=>'','db_name'=>'test','db_charset'=>'utf8',);//连接数据库$conn=mysql_connect($options['db_host'],$options['db_user'],$options['db_pwd']);mysql_select_db('test',$conn);mysql_query("SETNAMES{$options['db_charset']}",$conn);//获取数据库中的所有表$tableArr=array();$resource=mysql_query('从测试中显示表格',$conn);while($tempArr=mysql_fetch_row($resource)){$tableArr[]=$tempArr[0];}//对每个表循环操作foreach($tableArras$table){//(1)获取创建表的SQL语句$resource=mysql_query('SHOWCREATETABLE'.$table,$conn);$tempArr=mysql_fetch_row($resource);$sqlStr='DROPTABLEIFEXISTS'.$table.";\n";$sqlStr.=$tempArr[1].";\n";//(2)获取数据表中的字段信息$fieldArr=array();$resource=mysql_query('SHOWCOLUMNSFROM'.$table);while($tempArr=mysql_fetch_assoc($resource)){if($tempArr['Key']=='PRI'){$fieldArr['PRI']=$tempArr['Field'];}埃尔se{$fieldArr[]=$tempArr['Field'];}}//(3)查询每个字段的内容,拼成SQL字符串$sql='SELECT*FROM'.$table;if(!empty($fieldArr['PRI']))$sql.='按'.$fieldArr['PRI'].'排序。升序';$resource=mysql_query($sql);while($tempArr=mysql_fetch_row($resource)){//获取每张表对应的INSERTSQL语句$sqlStr.='INSERTINTO'.$table.'VALUES(';foreach($tempArras$value){$sqlStr.='\''.addslashes($value).'\',';//转义特殊字符}$sqlStr=substr($sqlStr,0,-2).");\n";}$sqlStr.="\n\n--============================$table\n\n";//(4)输出内容到文件$handle=fopen("db_bakup_{$options['db_name']}.sql",'a+');if(flock($handle,LOCK_EX)){fwrite($handle,$sqlStr);flock($handle,LOCK_UN);}fclose($handle);}//释放Mysql资源,关闭连接mysql_free_result($resource);mysql_close($conn);?>
