Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/bin/sh
- : "${dbname:="foodb"}"
- : "${dumpdir:="./tables"}"
- dbuser=root
- dbpass=root
- mkdir -p "$dumpdir"
- mysqldump -u"$dbuser" \
- --tab="$dumpdir" --fields-terminated-by=, --fields-enclosed-by='"' \
- --lines-terminated-by=0x0d0a \
- --skip-triggers --skip-dump-date --no-create-info \
- "$dbname"
- for file in "$dumpdir"/*.txt
- do
- f="${file##*/}"
- f="${f%.txt}"
- head="$(mysql -u"$dbuser" "$dbname" -e "SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE table_name = '${f}';" \
- | tail -n+2 \
- | xargs \
- | tr ' ' ','
- )"
- (printf -- '%s\n' "$head"; cat "$file";) > "${dumpdir}/${f}.csv"
- rm -f "$file"
- done
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement