• Skip to primary navigation
  • Skip to main content
  • Skip to footer

WPJohnny

WordPress Performance Guides and Reviews

  • Start a WordPress site
  • Hosting
  • Themes
  • Plugins
  • Blogging
  • Marketing

phpMyAdmin stuck when dropping tables

WordPress hosting Dec 16, 2021 by Johnny 1 Comment

Does your phpMyAdmin hang, freeze or load endlessly when dropping tables?

Here’s the quick fix:

  • Yes…you can drop database tables via SQL query or via command-line. But that’s too techy for many of my readers.
  • So do it the simpler way via phpMyAdmin like this…click “DROP” (located right-side of your tables), uncheck “Enable foreign key checks” and click [OK].
  • Or use wp-cli – navigate to the site’s root directory and use wp db reset.
  • Or maybe you have to clear browser cookies?

And that’s it!

(You only have to drop the heaviest tables, then can drop all the rest via “Select All” like you normally do.)

Share this post:

Share on FacebookShare on X (Twitter)Share on LinkedInShare on WhatsAppShare on EmailShare on SMS

Read all my posts on WordPress hosting

About Johnny

Right on the edge of WordPress development! 10+ years of WordPress design, development, hosting, speed optimization, product advisor, marketing, monetization. I do all that.

More WordPress Guides

How to Find a (Good) Translator

Awesome Motive isn’t awesome

RunCloud cloud-based VPS webhosting control panel 2019 review

Stock & Crypto Investing Advice from a NOOB

WP Rocket WordPress Cache Plugin – UNOFFICIAL GUIDE

How to become a WordPress coder

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Footer

More links

  • Gadget reviews
  • Try my free WPJ plugins
  • Join the WPJ FB Group
  • WPJ YouTube & newsletter
  • Become a WPJ Affiliate

Popular Reviews

  • Best WordPress Hosting
  • Best WordPress Themes
  • Best WordPress Plugins
  • Best WordPress Cache Plugins

Services

  • Speed optimization
  • Speed optimization courses
  • WordPress hosting
  • Hire me or other experts
  • Client login

About Johnny

10+ years of WordPress design, development, hosting, speed optimization, marketing.
Contact me.

newsletter block

Copyright 2025 | WordPress guides by Johnny Nguyen

Click to Copy