shell实现mysql的导入导出_shell脚本导入导出数据库

1、export.sh

#!/bin/bash

str=`date +%Y%m%d_%H%M%S`

outputfile=nec.dmp

rm -f /home/oracle/necDir/$outputfile

expdp nec/vnetoo DIRECTORY=necDir DUMPFILE=$outputfile SCHEMAS=nec logfile=logDir:nec_$str.log flashback_time=systimestamp

cp /home/oracle/necDir/$outputfile /home/oracle/backup/data/nec_$str.dmp

2、import.sh

#!/bin/sh

sqlplus "sys/sys as sysdba" @/home/oracle/shDir/rebuildNecUser.sql

impdp nec/vnetoo directory=necDir dumpfile=nec.dmp schemas=nec

3、rebuildNecUser.sql

drop user nec cascade;

CREATE USER nec IDENTIFIED BY vnetoo DEFAULT TABLESPACE "TS_NEC" TEMPORARY TABLESPACE "TS_NEC_TEMP";

GRANT "DBA" TO nec;

ALTER USER nec DEFAULT ROLE "DBA";

grant read, write on directory necDir to nec;

quit;