How to MANUALLY update the database from 2.7 to 2.7.1 ? (4 posts)

  1. sabinou
    Posted 7 years ago #


    My database has recently been through a huge plugin-generated expansion, and weights now around 20 MB when it is uncompressed.

    With that size of a DB, the automatic wordpress update from 2.7 to 2.7.1 failed (I will precise this is the new upgrade built-in version 2.7, I'm not using the former update plugin).

    I wonder : is it possible for me to MANUALLY update the database to make it 2.7.1 compatible ? And how ?
    I do not have root acccess to the sql server, but I have database owner priviledges in phpmyadmin, and I'm already used to performing sql requests, to backing up and restoring tables.

    If you're curious about my precise problem... Precisely, it stayed frozen at the "updating database" line for hours, and all pages of my blog, admin included, displayed the maintenance page. I had to manually restore my database with phpmyadmin and reupload the 2.7 core files.
    My database being too large to be handled in one shot by phpmyadmin (I have no access to the phpmyadmin .ini settings unfortunately), I had to manually split my sql database into smaller chunks, one per table, and the 3 largest tables (ratings, posts and comments) took several attempts to be successfully loaded.
    So, if possible, I wish to avoid having to reupload once again my database backup, I REALLY would prefer to manually update my database :D

    Thanks if you can help,
    Best regards,


  2. MichaelH
    Posted 7 years ago #

    As far as I know, 2.7 to 2.7.1 did not require a database upgrade.

  3. sabinou
    Posted 7 years ago #

    Really, Michael ?

    But then, why was the wordpress autoupdater telling it had to update the database, just when it froze ?!?

  4. MichaelH
    Posted 7 years ago #

    I believe that message is always displayed by the automatic updater.

    To prove that I did this:
    1. Installed 2.7
    2. Used the instructions at Upgrading WordPress to do the 2.7.1 upgrade
    3. When I did wp-admin/upgrade.php I got this message:
    No Upgrade Required
    Your WordPress database is already up-to-date!

Topic Closed

This topic has been closed to new replies.

About this Topic