So, until today we were testing our website. Now we want to switch to the next level and we need to empty the db in order to do that. This means that we would like to be at the starting point, with all the tables but no data.

There are a lot of tables and cross-references, so maybe truncating table by table is not the best choice..

Googling and asking friends, I guess I got it that the right solution has something to do with schema (more precisely exporting a schema).. is this right for our case? If yes, which are the necessary steps to perform this cleaning?

Debian & mysql 5.1