On 1/2/06, JJ <[EMAIL PROTECTED]> 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
