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.

Project Samples

Project Activity

See All Activity >

Categories

Database

Follow MySQL DB Cleanup Script

MySQL DB Cleanup Script Web Site

Other Useful Business Software

Compare Cell Phone Plans at Wirefly Compare Cell Phone Plans at Wirefly Icon
Compare Cell Phone Plans at Wirefly Icon

You’re probably paying too much for cell phone service. Wirefly compares hundreds of plans to help you save.

You’re probably paying too much for cell phone service. Wirefly compares hundreds of plans to help you save. Enter what you need (minutes, data, texts) into Wirefly’s innovative plan comparison tools and see your savings instantly.

Rate This Project

Login To Rate This Project

User Reviews

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

Additional Project Details

Intended Audience

Advanced End Users, System Administrators, Developers

User Interface

Web-based

Programming Language

PHP

Database Environment

MySQL

Registered

2012-02-26