MySQL DB Cleanup Script

beta

PHP Script to drop tables on all/some databases with wildcards

Add a Review
3 Downloads (This Week)
Last Update:
  Browse Code Git Repository

Screenshots

Description

I see there is no way in MySQL to drop tables using wildcards like 'temp_%', this simple PHP will help us do the following.

1. specify databases like 'anything%', so you check only the databases you need to.

2. specify tables like 'temp_%' , 'temp3_%' in an array so any number of temp wildcards possible.

3. loop through all databases and tables matching to drop the temp tables.

This makes it easy for you dropping many temp tables but be very careful about the wildcard, things may go completely wrong if you get the wildcard wrong.

MySQL DB Cleanup Script Web Site

Update Notifications





Write a Review

User Reviews

Be the first to post a review of MySQL DB Cleanup Script!

Additional Project Details

Intended Audience

Advanced End Users, Developers, System Administrators

User Interface

Web-based

Programming Language

PHP

Registered

2012-02-26
Screenshots can attract more users to your project.
Features can attract more users to your project.

Icons must be PNG, GIF, or JPEG and less than 1 MiB in size. They will be displayed as 48x48 images.