Re: [PHP-DB] DROP tables with prefix match
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
RE: [PHP-DB] DROP tables with prefix match
if it's only a one-off thing, you could use php to get all table names (mysql_list_tables) and then go thru and create an array of the names that match your criteria, then go thru that array and DROP each one progressivly. HTH Beau // -Original Message- // From: John Hughes [mailto:[EMAIL PROTECTED]] // Sent: Thursday, 16 May 2002 7:41 AM // To: [EMAIL PROTECTED] // Subject: [PHP-DB] DROP tables with prefix match // // // 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? // // __ // Do You Yahoo!? // LAUNCH - Your Yahoo! Music Experience // http://launch.yahoo.com // // -- // PHP Database Mailing List (http://www.php.net/) // To unsubscribe, visit: http://www.php.net/unsub.php // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] DROP tables with prefix match
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? __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php