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

License

Creative Commons Attribution License

Follow MySQL DB Cleanup Script

MySQL DB Cleanup Script Web Site

Other Useful Business Software
AI-powered service management for IT and enterprise teams Icon
AI-powered service management for IT and enterprise teams

Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity. Maximize operational efficiency with refreshingly simple, AI-powered Freshservice.
Try it Free
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

Operating Systems

Linux, BSD, Windows

Intended Audience

Advanced End Users, System Administrators, Developers

User Interface

Web-based

Programming Language

PHP

Database Environment

MySQL

Related Categories

PHP Database Software

Registered

2012-02-26