exportdb.sh

sudo mkdir -p /vagrant/backup
echo "Backing up db..."
sudo mysqldump --add-drop-database -u root -p'root' play > /vagrant/backup/db.sql
echo "DB backup done."

importdb.sh

if [ -e /vagrant/backup/db.sql ]
  then
    sudo mysql -p'root' play  < /vagrant/backup/db.sql
    echo "imported db..."
fi

Vagrantfile

config.trigger.before :halt do
  info "Dumping the database before shutting down..."
  run_remote  "bash /vagrant/assets/exportdb.sh"
  run_remote  "bash /vagrant/assets/gz-wpcontent.sh"
end