MySQL DB Cleanup Script
MySQL DB Cleanup Script is a PHP Script to drop tables on all/some databases with wildcards. There is no way in MySQL to drop tables using wildcards like 'temp_%', this simple PHP will help us do the following:
- specify databases like 'anything%', so you check only the databases you need to.
- specify tables like 'temp_%' , 'temp3_%' in an array so any number of temp wildcards possible.
- 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.
More popular Database Tool
- 1.6 KB
- 03/07/2012 14:02:42