Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/bash
- DBDUMP=$1
- USER=root
- PASS=
- DBNAME=mydb
- DIRLOCAL=/home/user/dumps/
- cd $DIRLOCAL$DBDUMP
- gzip -d *.gz
- pwd
- mysql -u $USER -p$PASS -D $DBNAME <<SQL
- DROP DATABASE condenast ;
- SQL
- mysqladmin -u $USER -p$PASS create $DBNAME
- for tb in `ls *.sql`
- do
- # un archivo por tabla
- mysql -u $USER $DBNAME < ${tb}
- done
Add Comment
Please, Sign In to add comment