I needed to install Concrete on a client's server. For some reason the first install didn't take, so I needed to delete and try again.
Their server won't let me use MySQL Workbench, so I'm stuck using phpMyAdmin (sigh). I don't have privileges to create databases, so I was stuck having to clear out the old tables so I could reinstall concrete to the same database.
If anyone else is ever in this situation, here is the query I needed for dropping all the tables (SQL statements ... not PHP):
DROP TABLE areagroupblocktypes;
DROP TABLE areagroups;
DROP TABLE areas;
DROP TABLE ataddress;
DROP TABLE atboolean;
DROP TABLE atbooleansettings;
DROP TABLE atdatetime;
DROP TABLE atdatetimesettings;
DROP TABLE atdefault;
DROP TABLE atfile;
DROP TABLE atnumber;
DROP TABLE atselectoptions;
DROP TABLE atselectoptionsselected;
DROP TABLE atselectsettings;
DROP TABLE attributekeycategories;
DROP TABLE areagroupblocktypes;
DROP TABLE areagroups;
DROP TABLE areas;
DROP TABLE ataddress;
DROP TABLE atboolean;
DROP TABLE atbooleansettings;
DROP TABLE atdatetime;
DROP TABLE atdatetimesettings;
DROP TABLE atdefault;
DROP TABLE atfile;
DROP TABLE atnumber;
DROP TABLE atselectoptions;
DROP TABLE atselectoptionsselected;
DROP TABLE atselectsettings;
DROP TABLE attributekeycategories;
DROP TABLE attributekeys;
DROP TABLE attributesetkeys;
DROP TABLE attributesets;
DROP TABLE attributetypecategories;
DROP TABLE attributetypes;
DROP TABLE attributevalues;
DROP TABLE blockrelations;
DROP TABLE blocks;
DROP TABLE blocktypes;
DROP TABLE btcontentfile;
DROP TABLE btcontentimage;
DROP TABLE btcontentlocal;
DROP TABLE btexternalform;
DROP TABLE btflashcontent;
DROP TABLE btform;
DROP TABLE btformanswers;
DROP TABLE btformanswerset;
DROP TABLE btformquestions;
DROP TABLE btgooglemap;
DROP TABLE btguestbook;
DROP TABLE btguestbookentries;
DROP TABLE btnavigation;
DROP TABLE btpagelist;
DROP TABLE btrssdisplay;
DROP TABLE btsearch;
DROP TABLE btslideshow;
DROP TABLE btslideshowimg;
DROP TABLE btsurvey;
DROP TABLE btsurveyoptions;
DROP TABLE btsurveyresults;
DROP TABLE btvideo;
DROP TABLE btyoutube;
DROP TABLE collectionattributevalues;
DROP TABLE collections;
DROP TABLE collectionsearchindexattributes;
DROP TABLE collectionversionblockpermissions;
DROP TABLE collectionversionblocks;
DROP TABLE collectionversionblockstyles;
DROP TABLE collectionversions;
DROP TABLE config;
DROP TABLE dashboardhomepage;
DROP TABLE downloadstatistics;
DROP TABLE fileattributevalues;
DROP TABLE filepermissionfiletypes;
DROP TABLE filepermissions;
DROP TABLE files;
DROP TABLE filesearchindexattributes;
DROP TABLE filesetfiles;
DROP TABLE filesetpermissions;
DROP TABLE filesets;
DROP TABLE filestoragelocations;
DROP TABLE fileversionlog;
DROP TABLE fileversions;
DROP TABLE groups;
DROP TABLE jobs;
DROP TABLE jobslog;
DROP TABLE logs;
DROP TABLE mailimporters;
DROP TABLE mailvalidationhashes;
DROP TABLE packages;
DROP TABLE pagepaths;
DROP TABLE pagepermissionpagetypes;
DROP TABLE pagepermissions;
DROP TABLE pages;
DROP TABLE pagesearchindex;
DROP TABLE pagestatistics;
DROP TABLE pagethemes;
DROP TABLE pagethemestyles;
DROP TABLE pagetypeattributes;
DROP TABLE pagetypes;
DROP TABLE pilecontents;
DROP TABLE piles;
DROP TABLE signuprequests;
DROP TABLE userattributekeys;
DROP TABLE userattributevalues;
DROP TABLE userbannedips;
DROP TABLE usergroups;
DROP TABLE useropenids;
DROP TABLE userprivatemessages;
DROP TABLE userprivatemessagesto;
DROP TABLE users;
DROP TABLE usersearchindexattributes;
DROP TABLE usersfriends;
DROP TABLE uservalidationhashes;
You can leave out btcontentfile if you haven't uploaded any files yet.
Sorry if you run into this problem on a linux server ... all these names are lowercase. My Linux server lets me use MySQL Administrator (now MySQL Workbench), which is WAY better and includes a "drop all" command.
Tada! :D