MySQL ODBC Connector - Drop all tables?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Drop all tables?

2006-01-02, 8:23 pm

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?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql? unsub...sie.nctu.edu.tw

Kevin Spencer

2006-01-02, 8:23 pm

On 1/2/06, JJ <jj@zolx.com> 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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links