# create new database file
mysqldump -v --host=127.0.0.1 --user=username --password=password database_name > ./database_file.sql

# delete durrent database
mysqladmin --host=127.0.0.1 --user=username --password=password drop database_name

# create durrent database
mysqladmin --host=127.0.0.1 --user=username --password=password create database_name

#  restore database file
mysql -v --host=127.0.0.1 --user=username --password=password database_name < ./database_file.sql