This is a small technical tip that we’re posting in case it can help another WordPress user. For our readers who don’t know or care what WordPress is, just delete this message. For those who do, WordPress is a blogging and content management system which is used by millions of users to create and manage online content, from the most insignificant blogs (like http://myphilippinelife.com or http://goiloilo.com) to major newspapers such as the blogs of the New York Times.
I did a really foolish thing. I was migrating our blog goiloilo.com to a new domain, myphilippinelife.com. Since we had quite a few links to and readers of our old blog, goiloilo.com, we wanted to redirect them to the new site, myphilippinelife.com.
Using the wonderful Redirection plug-in for WordPress, we redirected certain popular posts from the old site to the new. That worked fine. Then we added a wild-card redirect to send all the hundreds of other posts automatically to the new site’s homepage. It worked beautifully. For example, users would click the goiloilo.com link http://goiloilo.com/buying-a-laptop-computer-for-the-philippines and be whisked to http://myphilippinelife.com/buying-a-laptop-computer-philippines/ automatically.
I logged out of my WordPress goiloilo.com administrative account. When I went to log back in again, to http://goiloilo.com *I* was redirected to http://myphilippinelife.com/. We could not access our own blog. I could not get in to delete that wild card redirect. I was locked out of our own site.
I tried everything. Here’s how I finally broke back in to our site. I logged into our CPanel account. Both the new and old site are on the same shared server. Then I opened phpMyAdmin. That’s a utility which allows you to see and edit the SQL database which underlies WordPress. Mistakes in using phpMyAdmin can be disastrous, as I found out when I did a global delete of “goiloilo.com” from my SQL database rather than a search for goiloilo.com and replacement with myphilippinelife.com. That has resulted in hundreds of hours of manual work repairing links to hundreds and hundreds of photos.
Getting back to my lockout problem, phpMyAdmin allowed me to browse the redirects that the Redirection plug-in had created and to select and delete the wildcard redirect which was locking us out of our own site. Problem solved. We hope this may help anyone else who does the same foolish thing!
Here’s a link to the excellent Redirection plug-in web site.