Export
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
#!/bin/bash $username=<username> $password=<password> $exportfile=<importfile> $exportlog=<importlog> $DBNAME=<dbname> mknod pipe p cat pipe |gzip -c >$exportfile & exp $username/$password@$DBNAME file=pipe DIRECT=Y CONSISTENT=Y LOG=$exportlog sleep 5 rm pipe |
Import
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
#!/bin/bash $username=<username> $password=<password> $importfile=<importfile> $importlog=<importlog> $DBNAME=<dbname> mknod pipe p gunzip < $importfile > pipe & imp $username/$password@$DBNAME file=pipe DESTROY=Y FULL=Y IGNORE=Y LOG=$importlog sleep 5 rm pipe |