Problem upgrading to 2.9.2

  • thinker822

    (@thinker822)


    15 years ago

    I recently installed the 2.9.2 update manually since the automated upgrade feature in my previous revision was being ornery. After installing I received the message “You cannot upgrade because WordPress 2.9.2 requires MySQL 4.1.2 or higher. You are running 4.0.27”. I called my ISP and requested a MySQL upgrade and was informed that they don’t do upgrades but I can create a new database and import the old data. The only trouble with that was I couldn’t login to my existing data.

    I downloaded an older version of WordPress (2.8) and moved that via FTP over the 2.9.2. I can now get into my website backend once again.

    I’m poised to call my ISP and have them walk me through the export process of my old database. Then I intend to create a new MySQL 5 database to import the data to.

    The trouble as I see it is in pointing my existing wordpress installation to the correct database at my host.

    Questions:

    1. How do I easily tell which database my site is currently connected to? (I’ve made several over the years, naturally all are similar in name and none have date stamps)

    2. How do I make the adjustmen to accomodate the new MySQL 5 database which will house my historical data?

    3. Will I lose anything?

Viewing 5 replies - 1 through 5 (of 5 total)
  • rainer23

    (@rainer23)

    Usually people get only one database when running a domain. You can have multiple wordpress blogs running on one database when installing them with a different prefix, by default the database entries start with wp, $table_prefix = ‘wp_’;. As soon you change this wp into vp, one database doesnt overwrite the other. There are lots of videos how to restore a wp database, https://www.youtube.com/watch?v=trbhRgIlTIQ
    If you don’t know which database contains what, just import it into your local wordpress database and read the blog entries.

    Thread Starter thinker822

    (@thinker822)

    Thanks. I’ve created multiple domains when I was figuring things out ages ago, most of them have never been used. I was never very good about cleaning up the mess after the fact which is why I find myself in this predicament.

    thanks again

    esmi

    (@esmi)

    1. Examine your wp-config.php file. That should tell you the database name.

    2. If I understand your question correctly, amend your wp-config.php file to point to the new database.

    esmi

    (@esmi)

    Usually people get only one database when running a domain.

    Really? I have at least 10 dbs per hosting package.

    I had exactly the same problem. I have also tried to creating a new database at version 5.0.22 and then taking a backup of the current db and restoring it to the new db but I get this error:

    ERROR 1064 (42000) at line 185: You have an error in your SQL syntax; check the
    manual that corresponds to your MySQL server version for the right syntax to use
    near ‘default varchar(128) NOT NULL default ‘0’,
    active char(1) NOT NULL default ‘1” at line 7

    any advice would be useful?

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Problem upgrading to 2.9.2’ is closed to new replies.