mysql schema backup scripts

#!/bin/bash

date=`date +%Y-%m-%d-%H`

/usr/local/mysql/bin/mysqldump -u root --no-data federated --ignore-table=federated.schedule_traffic_log --routines > /root/mysql_schema/federated_schema.sql

sleep 1

/usr/local/mysql/bin/mysqldump -u root --no-data logs  --routines > /root/mysql_schema/logs_schema.sql