The output present in the file mydb-backup.sql will contain a series of MySQL statements and exactly same database can be rebuilt from scratch using this file.
Let us regenerate the same database on a different host or on the same host by deleting the existing database.
If you want to delete a database, use the following MySQL command.
[neo@techpulp ~]# mysql -u root -p
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> drop database mydb;
Query OK, 0 rows affected (0.01sec)
Now let us just create a blank database using the following MySQL command.