[Typo3] deleting all tables without the database itself

[Anders Tillebeck]

Roman S. wrote:
> Hi everbody,
> 
> I was looking for an answer but didn't find how to get this done. If I 
> want to delete all tables in a database without entering a command like 
> mysql DROP TABLE `tt_ölj`, `tx_asdf`, tx_asdf_sdf`; what can I do in 
> such a case?
> 
> If I simply use the drop database command the entire database will be 
> deleted and thats not good actually.
> 
> So is there a possibility to delete everything in a database but not the 
> database itself. I was looking at mysql.com but hasn't made me smarter.
> 
> 
> Thanks in advance,
> 
> Roman Setzmüller


PhpMyAdmin:
If you use MySQL it is easy to do through a browser using PhpMyAdmin. If 
you are talking about all tables in a Typo3 installation then you have 
the PhpMyAdmin present all ready in your backend.
  - I guess this is not the answer you are looking for since it is to 
obviously

If you need to make a script:
Make a dump of the database. Edit the scipt so all CREATE and INSERT's 
are deleted. Then you will end up with a script containing DROP commands 
for all existing tables :-)

BR. Anders