Re: Drop all tables?

[Kevin Spencer]

On 1/2/06, JJ <jj@stripped> wrote:
> Is there an easy way to drop all (MyISAM) tables of a MySQL 3.23 database
> besides deleting it and then recreating an empty database?

Read up on mysqldump.  For 3.23, something like the following should
do the trick:

mysqldump databasename --add-drop-table --no-data > your_output_file.sql

And then import it:

mysql databasename < your_output_file.sql

--
Kevin.