Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #! /bin/bash
- user="root"
- pass="alexander"
- bd="sakila"
- salida="/root/Downloads/serializado"
- extension="csv"
- if [ ! -d $salida ]; then
- mkdir -p $salida
- fi
- for tabla in $(mysql -u$user -p$pass $bd -Be "show tables" | sed 1d )
- do
- mysql -u$user -p$pass $bd -e "select * from $tabla" | sed 's/\t/,/g'> $salida/$tabla.$extension
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement