From: Kevin Spencer Date: January 2 2006 9:43pm Subject: Re: Drop all tables? List-Archive: http://lists.mysql.com/mysql/193430 Message-Id: <7f5545290601021343w3b2ed302k8c4c250787d0139@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 1/2/06, JJ 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.