I need to drop the following tables from my database. As you can see its basically a load of redundant vB tables... Any clues why I'm getting an error? DROP TABLE IF EXISTS zzz_vb3_adminhelp DROP TABLE IF EXISTS zzz_vb3_administrator DROP TABLE IF EXISTS zzz_vb3_adminlog DROP TABLE IF EXISTS zzz_vb3_adminmessage DROP TABLE IF EXISTS zzz_vb3_adminutil DROP TABLE IF EXISTS zzz_vb3_announcement DROP TABLE IF EXISTS zzz_vb3_announcementread DROP TABLE IF EXISTS zzz_vb3_attachment DROP TABLE IF EXISTS zzz_vb3_attachmentpermission DROP TABLE IF EXISTS zzz_vb3_attachmenttype DROP TABLE IF EXISTS zzz_vb3_attachmentviews DROP TABLE IF EXISTS zzz_vb3_avatar DROP TABLE IF EXISTS zzz_vb3_bbcode DROP TABLE IF EXISTS zzz_vb3_calendar DROP TABLE IF EXISTS zzz_vb3_calendarcustomfield DROP TABLE IF EXISTS zzz_vb3_calendarmoderator DROP TABLE IF EXISTS zzz_vb3_calendarpermission DROP TABLE IF EXISTS zzz_vb3_cpsession DROP TABLE IF EXISTS zzz_vb3_cron DROP TABLE IF EXISTS zzz_vb3_cronlog DROP TABLE IF EXISTS zzz_vb3_customavatar DROP TABLE IF EXISTS zzz_vb3_customprofilepic DROP TABLE IF EXISTS zzz_vb3_datastore DROP TABLE IF EXISTS zzz_vb3_deletionlog DROP TABLE IF EXISTS zzz_vb3_editlog DROP TABLE IF EXISTS zzz_vb3_event DROP TABLE IF EXISTS zzz_vb3_externalcache DROP TABLE IF EXISTS zzz_vb3_faq DROP TABLE IF EXISTS zzz_vb3_forum DROP TABLE IF EXISTS zzz_vb3_forumpermission DROP TABLE IF EXISTS zzz_vb3_forumread DROP TABLE IF EXISTS zzz_vb3_geek_autolink DROP TABLE IF EXISTS zzz_vb3_geek_autolink_cats DROP TABLE IF EXISTS zzz_vb3_geek_autolink_codes DROP TABLE IF EXISTS zzz_vb3_geek_autolink_impressions DROP TABLE IF EXISTS zzz_vb3_geek_autolink_stats DROP TABLE IF EXISTS zzz_vb3_geek_autolink_styles DROP TABLE IF EXISTS zzz_vb3_holiday DROP TABLE IF EXISTS zzz_vb3_icon DROP TABLE IF EXISTS zzz_vb3_imagecategory DROP TABLE IF EXISTS zzz_vb3_imagecategorypermission DROP TABLE IF EXISTS zzz_vb3_infraction DROP TABLE IF EXISTS zzz_vb3_infractiongroup DROP TABLE IF EXISTS zzz_vb3_infractionlevel DROP TABLE IF EXISTS zzz_vb3_language DROP TABLE IF EXISTS zzz_vb3_mailqueue DROP TABLE IF EXISTS zzz_vb3_moderation DROP TABLE IF EXISTS zzz_vb3_moderator DROP TABLE IF EXISTS zzz_vb3_moderatorlog DROP TABLE IF EXISTS zzz_vb3_passwordhistory DROP TABLE IF EXISTS zzz_vb3_paymentapi DROP TABLE IF EXISTS zzz_vb3_paymentinfo DROP TABLE IF EXISTS zzz_vb3_paymenttransaction DROP TABLE IF EXISTS zzz_vb3_phrase DROP TABLE IF EXISTS zzz_vb3_phrasetype DROP TABLE IF EXISTS zzz_vb3_plugin DROP TABLE IF EXISTS zzz_vb3_pm DROP TABLE IF EXISTS zzz_vb3_pmreceipt DROP TABLE IF EXISTS zzz_vb3_pmtext DROP TABLE IF EXISTS zzz_vb3_podcast DROP TABLE IF EXISTS zzz_vb3_podcasturl DROP TABLE IF EXISTS zzz_vb3_poll DROP TABLE IF EXISTS zzz_vb3_pollvote DROP TABLE IF EXISTS zzz_vb3_post DROP TABLE IF EXISTS zzz_vb3_posthash DROP TABLE IF EXISTS zzz_vb3_postindex DROP TABLE IF EXISTS zzz_vb3_postparsed DROP TABLE IF EXISTS zzz_vb3_product DROP TABLE IF EXISTS zzz_vb3_productcode DROP TABLE IF EXISTS zzz_vb3_productdependency DROP TABLE IF EXISTS zzz_vb3_profilefield DROP TABLE IF EXISTS zzz_vb3_ranks DROP TABLE IF EXISTS zzz_vb3_regimage DROP TABLE IF EXISTS zzz_vb3_reminder DROP TABLE IF EXISTS zzz_vb3_reputation DROP TABLE IF EXISTS zzz_vb3_reputationlevel DROP TABLE IF EXISTS zzz_vb3_rssfeed DROP TABLE IF EXISTS zzz_vb3_rsslog DROP TABLE IF EXISTS zzz_vb3_search DROP TABLE IF EXISTS zzz_vb3_session DROP TABLE IF EXISTS zzz_vb3_setting DROP TABLE IF EXISTS zzz_vb3_settinggroup DROP TABLE IF EXISTS zzz_vb3_sigparsed DROP TABLE IF EXISTS zzz_vb3_sigpic DROP TABLE IF EXISTS zzz_vb3_smilie DROP TABLE IF EXISTS zzz_vb3_stats DROP TABLE IF EXISTS zzz_vb3_strikes DROP TABLE IF EXISTS zzz_vb3_style DROP TABLE IF EXISTS zzz_vb3_subscribeevent DROP TABLE IF EXISTS zzz_vb3_subscribeforum DROP TABLE IF EXISTS zzz_vb3_subscribethread DROP TABLE IF EXISTS zzz_vb3_subscription DROP TABLE IF EXISTS zzz_vb3_subscriptionlog DROP TABLE IF EXISTS zzz_vb3_subscriptionpermission DROP TABLE IF EXISTS zzz_vb3_tachyforumpost DROP TABLE IF EXISTS zzz_vb3_tachythreadpost DROP TABLE IF EXISTS zzz_vb3_template DROP TABLE IF EXISTS zzz_vb3_templatehistory DROP TABLE IF EXISTS zzz_vb3_thread DROP TABLE IF EXISTS zzz_vb3_threadrate DROP TABLE IF EXISTS zzz_vb3_threadread DROP TABLE IF EXISTS zzz_vb3_threadredirect DROP TABLE IF EXISTS zzz_vb3_threadviews DROP TABLE IF EXISTS zzz_vb3_upgradelog DROP TABLE IF EXISTS zzz_vb3_user DROP TABLE IF EXISTS zzz_vb3_useractivation DROP TABLE IF EXISTS zzz_vb3_userban DROP TABLE IF EXISTS zzz_vb3_userfield DROP TABLE IF EXISTS zzz_vb3_usergroup DROP TABLE IF EXISTS zzz_vb3_usergroupleader DROP TABLE IF EXISTS zzz_vb3_usergrouprequest DROP TABLE IF EXISTS zzz_vb3_usernote DROP TABLE IF EXISTS zzz_vb3_userpromotion DROP TABLE IF EXISTS zzz_vb3_usertextfield DROP TABLE IF EXISTS zzz_vb3_usertitle DROP TABLE IF EXISTS zzz_vb3_word Code (markup):
"DROP TABLE will not return an error or raise exception if the table doesn't exist. " Might want to try without the IF EXISTS. One thought is that there are dependencies with the tables, but the error code notes a syntax error. Try dropping them one at a time. if you get an error, move on and come back to the table. http://dev.mysql.com/doc/refman/4.1/en/drop-table.html