bitscn.com
导出脚本1: 表元数据, 存储过程, 函数, 视图, 小表数据(不包含元数据)的导出
rem 每次导出到当前日期文件夹 @echo wscript.echo dateadd(d,0,date)>getolddate.vbs@for /f %%a in ('cscript /nologo getolddate.vbs') do @set olddate=%%aecho %olddate%@del getolddate.vbs@rem 替换/为-@set current_date=%olddate:/=-%echo %current_date%set prefix_folder=d:/database_backup/backup_daily/sqlset dump_ip=localhostset user_name=rootset password=set database=db_namemkdir %prefix_folder%/%current_date%/rem 整库元数据及存储过程,函数等mysqldump -h %dump_ip% -u%user_name% -p%password% -d %database% >%prefix_folder%/%current_date%/create_tables.sqlmysqldump -h %dump_ip% -u%user_name% -p%password% -ntd -r -e %database% --triggers=false >%prefix_folder%/%current_date%/sp_fn.sqlrem 某表的数据mysqldump -h %dump_ip% -u%user_name% -p%password% -t %database% table_name>%prefix_folder%/%current_date%/table_name.sql
导出脚本2: 每月月初导出上个月的数据, 数据量稍大的导出
@del getolddate.vbs@rem 替换/为-@set current_date=%olddate:/=-%echo %current_date%set prefix_folder=d:/database_backup/backup_monthly/sqlset dump_ip=localhostset user_name=rootset password=set database=db_namemkdir %prefix_folder%/%current_date%/rem 导出上个月的数据mysqldump -h %dump_ip% -u%user_name% -p%password% -t %database% article_detail --where=extracted_time between date_sub(date_sub(date_format(now(),'%y-%m-%d'),interval extract(day from now())-1 day),interval 1 month) and date_sub(date_sub(date_format(now(),'%y-%m-%d'),interval extract(day from now())-1 day),interval 0 month) --skip-opt -e --max_allowed_packet=10240000 --net_buffer_length=16384 --triggers=false >%prefix_folder%/%current_date%/article_detail.sql
导入脚本:
rem 需要手工设置: 设置需要导入的数据库服务器ip, 在数据库服务器本机操作dump_ip可用localhostset dump_ip=localhostset user_name=rootset password=set database=db_nameset folder_dir=d:/database_backup/backup_monthly/sql/2012-6-9mysql -h %dump_ip% -u%user_name% -p%password% %database% bitscn.com