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.

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to