KNEL DB backup script

From Knelcorpwiki

Jump to: navigation, search
#!/bin/bash

username="root"
password="xxxxxxx"


dblist=`mysql -u $username -p$password -e "show databases;" | grep -v Database`

for db in $dblist
do
mysqldump -u $user -p$password $db > $db.sql
done
Personal tools