title: How to force truncate all tables(which are all innodb) in a database in MySQL?
body: <p>I think I get foreign key constraint error when I try to truncate innodb tables. I was not having problems with this when using MyISAM.</p>
  
  <p>Is there an easy way to force truncate all tables? Or should I just make a script to drop the database, create new one and then create the tables from scratch?</p>