基于MySQL的SDCORS数据库自动压缩备份机制

Automatic Compression and Backup Mechanism of SDCORS Database Based on MySQL

通过编写MySQL批处理压缩备份脚本,设置Windows自动定时服务,利用MySQL导入导出工具mysqldump.exe实现SDCORS数据库的自动定时压缩备份功能,采用不同的压缩级别对133个SDCORS基准站10天的观测数据和解算数据进行压缩备份测试,通过比较选择出最优备份压缩级别。

By writing MySQL batch compress backup script,using import and export tools mysqldump.exe,setting the Windows automatic timing service,this paper makes SDCORS database automatic timing compress backup realized.This paper uses 133 SDCORS station observe data and calculate result data of 10 days for different compression levels tests.Finally,by comparing the efficiency of different tests,we chose the optimal level of backup compression.