phpMyAdmin causes wordpress database to dissapear!!

  • Hi There, My first post here on the forums, unfortunately it is not good news, any help would be much appreciated.

    OK, so I’ve been building myself a CMS driven website using wordpress as I’ve heard a lot of good things. It’s been fun learning it, and I was almost there with what I was aiming for.

    The problem came when I wanted to know a bit about what info was stored in the database and how. I used a version of phpMyAdmin that I had sitting on my server to look at the wordpress database, and it showed up empty. Next thing I knew my site was asking me to setup wordpress again!! The database had been wiped! Not good… but I spent a few hours rebuilding it (I still had the Theme luckily) and then again today I wanted to know something about the database, so I installed the phpMyAdmin wordpress plugin thinking this would be safe…

    Well, I’ve just clicked on it in tools, and it brought up a list of tables, I clicked on one of the tables to expand it and Boom!!! the same thing happened. Looks like the database has been wiped again!

    Now, I don’t mind rebuilding again one last time but can anyone shed any light on why this is happening?

    I know you’ll say ‘stop looking at the database’ but it should be safe to do so right? I’m not pressing any ‘delete all’ buttons or anything, just the very use of phpMyAdmin seems to render the database useless.

    Thanks Guys…

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter lumiere

    (@lumiere)

    OK, disaster over (for now)…. so I went into the wordpress database area using my hosting backend. I added a new user, deleted the old one and then renamed the new user back to the original and POP! It all came back again.

    So it seems the use of phpMyAdmin managed to corrupt my database user account, forcing it to think there was no database. Still no idea why this would happen. Any ideas?

    Where have you got phpmyadmin from? I’d suggest collecting the latest source to reinstall it.

    Thread Starter lumiere

    (@lumiere)

    Well the second time around I used a wordpress plugin ‘WP-phpMyAdmin’, which I assume has been tested and is working fine for most users. I must say I’m a little wary to use it now, although no-one else seems to have had this problem.

    I cannot really see any reason why phpmyadmin would corrupt your database. I was figuring it was maybe an issue with your phpmyadmin install, but the plugin has its own files, so it is a mystery.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘phpMyAdmin causes wordpress database to dissapear!!’ is closed to new replies.