Re: DROP tables with prefix match
| From: | Jason Wong | Date: | Thu, 16 May 2002 06:04:40 +0000 |
| Subject: | Re: DROP tables with prefix match | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-19209@lists.php.net to get a copy of this message | ||
On Thursday 16 May 2002 07:40, John Hughes wrote:
> I need to rebuild a PHP-mySQL site that has an extensive table
> structure. Is there a way to DROP all tables that start with a
> certain prefix?
If you have access to the server running mysql then you could try deleting the
actual files holding the tables. If you're using MyISAM tables then each
table is held in 3 files -- table.frm, table.MYD, table.MYI
*** WARNING ***
I've not tried this before. It may be a good idea to backup your data first :)
*** WARNING ***
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Adapt. Enjoy. Survive.
*/