Retrieving page contents from WordPress database

  • Resolved MarSim

    (@marsim)


    10 years, 3 months ago

    Hello,

    I wanted to deactivate SSL on my web site because I needed to change the domain name, however, in spite of all my efforts, I can no longer enter into the WordPress back office.

    I automated the re-installation of Apache, MySQL, PHP and WordPress so I can recreate a functional WordPress installation in no time. Also, I have a very recent backup of my site contents, obtained using this command on my Debian VPS:

    mysqldump -u root -p$sDbRootPasswd  --single-transaction $sDbName > /$sDbName.sql

    I can then restore the database like this:

    echo "DROP DATABASE $sDbName;" | mysql -u root -p$sDbRootPasswd
echo "CREATE DATABASE $sDbName;" | mysql -u root -p$sDbRootPasswd
mysql -u root -p$sDbRootPasswd $sDbName < $sDbName.sql

    The problem is that this breaks WordPress and I can no longer connect to the back office after restoring the database.

    As I only have about 20 pages on my site, I could recreate them easily provided I would have access to the text contents of the web pages (I have access to all the images which are saved elsewhere). Is there a way, other than WordPress, to access the page contents in my WordPress sql database?

    Thank you very for any suggestions you might have.

    Marc

Viewing 6 replies - 1 through 6 (of 6 total)
  • Mark Ratledge

    (@songdogtech)

    10 years, 3 months ago

    Have you tried https://www.adminer.org/ ?

    Thread Starter MarSim

    (@marsim)

    10 years, 3 months ago

    Hello songdogtech,

    Thank you very much for your suggestion.

    I installed the Adminer plugin and was able to see that it imported successfully the entire WordPress database (in the form of a .sql file obtained from a back-up made a couple of days ago) but then the site broke and I was thrown out of WordPress.

    I will next try to use Adminer as a stand-alone tool so that I do not have the same problem. I will report my findings soon.

    Best Regards,

    Marc

    Mark Ratledge

    (@songdogtech)

    10 years, 3 months ago

    What exactly are you trying to do? Change the domain? Go from https to http?

    See Moving WordPress « WordPress Codex

    and

    WordPress Serialized PHP Search Replace Tool

    Thread Starter MarSim

    (@marsim)

    10 years, 3 months ago

    Hello songdogtech,

    We decided to change the name of the domain, say from http://www.mysite1.ca to http://www.mysite2.ca. Since the SSL certificate was generated based on http://www.mysite1.ca, I thought I would first deactivate SSL, make the necessary changes in WordPress and then go back to SSL with a new certificate based on http://www.mysite2.ca.

    However, when I deactivated SSL in Apache, using

    a2dismod ssl
a2dissite default-ssl
service apache2 restart

    I was never able to get back into the WordPress back office using http://www.mysite1.ca (or https://www.mysite1.ca for that matter).

    I will have a look at the links you provided.

    Thanks again.

    Marc

    Thread Starter MarSim

    (@marsim)

    10 years, 3 months ago

    Hello songdogtech,

    I think I have found a way to sort out my problem.

    First, I was able to re-enter into the WordPress back office and access all my pages, as follows:

    1. Reinstall Apache, PHP, MySQL and WordPress (this is all automated in a single bash script)
    2. Retrieve from my backup the SSL certificate and Apache files modified to enable SSL
    3. Execute the following commands:
      a2enmod ssl (this is what I was missing previously)
      service apache2 restart

    Then, I visited the links you provided in your last reply and concluded that they are intended for people having a deeper web site management knowledge than mine.

    I therefore plan to use a slightly tedious method to implement the domain name change, but which should prevent me from having a nervous breakdown: I will take the original html code of each page, paste it in the new site and manually fix the links to images and other pages.

    Thanks again for your attention in this matter.

    Regards,

    Marc

    Thread Starter MarSim

    (@marsim)

    10 years, 3 months ago

    Hello,

    I started recreating my site and the tedious method already mentioned seems to work.

    I hope that eventually the WordPress page content will be more loosely linked to the web site domain name.

    Regards,

    Marc

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Retrieving page contents from WordPress database’ is closed to new replies.