Support » Installing WordPress » “Drop table” command not working in MySQL

  • Groan! The drop table command doesn’t truly clear away tables from an existing WordPress database, so that I can import identically named tables to bring the database up to date at my blog’s new virtual home.

    To-be-imported data comes out of a dump in verson 4.0.24, while the destination database is 4.0.17 at least. So a version clash isn’t the problem, is it? I’m hoping I’m just overlooking something obvious, so that there’ll be an easy fix.

    When I do drop table commands, MySQL says I’ve succeeded. But then when I try an import again, I get an error message protesting that there is an identical table–usually wp_categories.

    I’ve even deleted the WP-related database from the new server–and yet still see an error message re an unwanted ghost table.

    What’s going on? Is WP refreshing tables behind my back? Or is a cache at my new Web host doing something evil?

    Just to anticipate questions, the new host apparently does not include a GUI-style MySQL admin tool.

    I suppose I could try workarounds, but I’d rather get at the root of the problem–for the sake of safety and integrity of my database.

    Thanks,
    David Rothman | TeleRead.org | 703-370-6540
    Blog (existing host): http://www.teleread.org/blog

Viewing 2 replies - 1 through 2 (of 2 total)
  • I don’t know of any ‘database caching’ for MySQL that would cause this. This will seem like salt in the wound, but are you ABSOLUTELY certain you’re accessing the correct database?

    Anyway, one thing to try: change the $table_prefix variable in wp-config.php to something else, say ‘tr_’, and try to install again.

    Thread Starter davidrothman

    (@davidrothman)

    This is good stuff. Will try. I’ll also welcome more suggestions from you and others. Results ahead of vanity! Thanks. DR

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘“Drop table” command not working in MySQL’ is closed to new replies.