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
