How to delete all data from any database in MySQL while retaining database structure?

Question

I want to delete all the data from one database but the structure of the table needs to be there. What will be the cleanest way to do that?

Answer 1

1. Disable foreign key check.
2. Truncate all tables.
3. Enable foreign key check back.

Alternatively:

1. Backup the database without data (only tables, functions, procedures, triggers).
2. Restore into new database.