数据库导出脚本:

导出 事件,存储过程,函数

mysqldump -uroot -p -h192.168.0.27 --events --routines --default-character-set=utf8 --skip-add-drop-table --databases dossier > dossier.sql

卷宗库导出(忽略大表)

mysqldump -uroot -p123456 -h192.168.0.21   business $(mysql -uroot -p123456 -h192.168.0.21 -D business -Bse "
select table_name from information_schema.tables where table_schema='business' and
  table_name not in('rpid_hyid_mapping','storage_file','sys_task','hy_push_log')
   and table_name not like 'file_info%' and table_name not like '%_directory_info'
")  | gzip > ./business.sql.gz
作者:崔启旭  创建时间:2023-04-11 14:56
最后编辑:崔启旭  更新时间:2024-11-15 23:02