We are building a web app. Because of it's complexity, it is necessary to have a test environment in which to test changes.
I have set up a database on the test server (same as live).
From time to time I would like to truncate ALL tables I reload with SQL from a backup of the live database. There may be both structure & data changes.
Is there a way I can do that with phpmyadmin? Like truncate ALL or something like that?