Importing WordPress Database

I made some changes to quite a few page files in my wordpress production site. And I don’t want to do the same changes again in my development site. So I used phpMyAdmin to export the production database and then import it to my development database. Wow, it turned out to be a mess. Since I imported the whole production wordpress database to development. Now some links in my development site points to the production site. And the worst part is my development site wordpress admin login page was now unaccessible. Luckily, phpMyAdmin still works which allowed me to change the wordpress options table manually. So I changed my development site url back to local and things work again. I was thinking to to reinstall WordPress at first. Thank god I don’t have to. Be very careful when you import wordpress database using phpMyAdmin.

Leave a Reply

Your email address will not be published.