mysqldump几张表结构及数据 dump数据库

mysqldump -uroot -p** --databases dbname> $DumpFile

 

mysqldump -uroot -ppw 数据库名 t_project_productType KeyEvent GoodsArrivedInfo OrderGoodsList GoodsDeliverInform FileType ProductType Phases FileAttachment FileBag misapi_projectChange Project Department T_USER_POSITION POSITION UserT GoodsDeliverInfo ResourceUsage CashReturnPlan AppendCashReturnPlan >/gitsvn/mysqldatabak/pmiswaibao/pmiswaibao.sql

 

 

 

mysqldump -uroot -ppasswd 数据库名 v_misapi_project v_misapi_projectstatus v_misapi_department v_misapi_sizonemanager v_misapi_simanager v_misapi_siworker v_misapi_userPosition v_misapi_sidepartment v_misapi_goodfinisheddate v_misapi_user v_misapi_projectincomeview goodfinisheddate simanager sidepartment siworker sizonemanager projectincomeview appendcashreturnview >/gitsvn/mysqldatabak/pmiswaibao/pmiswaibao-view.sql

 

 

mysqldump -h 192.168.10.20 -uroot -ppmo2009 dy_pmis t_hr_pit_default_columns t_hr_pit_default_rate_info t_hr_pit_default_type_columns t_hr_pit_default_values t_hr_pit_issue t_hr_pit_issue_excelColumn t_hr_pit_issue_record t_hr_pit_issue_result_record t_hr_pit_result_columns>d:\pit.init.sql