Title: Problem upgrading to 2.9.2
Last modified: August 19, 2016

---

# Problem upgrading to 2.9.2

 *  [thinker822](https://wordpress.org/support/users/thinker822/)
 * (@thinker822)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/problem-upgrading-to-292/)
 * 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](https://wordpress.org/support/users/rainer23/)
 * (@rainer23)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/problem-upgrading-to-292/#post-1389128)
 * 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, [http://www.youtube.com/watch?v=trbhRgIlTIQ](http://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](https://wordpress.org/support/users/thinker822/)
 * (@thinker822)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/problem-upgrading-to-292/#post-1389154)
 * 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](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/problem-upgrading-to-292/#post-1389192)
 * 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](https://wordpress.org/support/users/esmi/)
 * (@esmi)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/problem-upgrading-to-292/#post-1389193)
 * > Usually people get only one database when running a domain.
 * Really? I have at least 10 dbs per hosting package.
 *  [hubbers](https://wordpress.org/support/users/hubbers/)
 * (@hubbers)
 * [15 years, 11 months ago](https://wordpress.org/support/topic/problem-upgrading-to-292/#post-1389438)
 * 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.

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)
 * [my-sql](https://wordpress.org/support/topic-tag/my-sql/)
 * [Upgrade 2.9.2](https://wordpress.org/support/topic-tag/upgrade-2-9-2/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 5 replies
 * 4 participants
 * Last reply from: [hubbers](https://wordpress.org/support/users/hubbers/)
 * Last activity: [15 years, 11 months ago](https://wordpress.org/support/topic/problem-upgrading-to-292/#post-1389438)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics