Some Mysql Bash Script

 #!/bin/bash

user="root"

pass="root"

db="database"

mysqldump --user=$user --password=$pass $db > "/home/user/database.sql"

mysql --user=$user --password=$pass $db < /home/user/database.sql

mysql --user=$user --password=$pass $db << EOF

INSERT INTO $TABLE (id, name, email) VALUES (NULL, "Jon", "jon@gmail.com");

EOF

mysql --user=$user --password=$pass $db -e "SELECT * FROM table"