Title: Upgrading blog database problem
Last modified: August 19, 2016

---

# Upgrading blog database problem

 *  Resolved [edb](https://wordpress.org/support/users/edb/)
 * (@edb)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/upgrading-blog-database-problem/)
 * I’ve been trying to upgrade my WP blog to 2.9x for a while now. Long story short,
   the problem is this:
 * – The blog is hosted on 1and1.
    – The current database uses MySQL v4.0. – WP 
   2.9x requires a MySQL database v5.0. – I can create a v5 database no problem.
   However, 1and1 won’t let me copy my old database to the new one because it is
   greater than 2mb in size (its 5mb, just 5% of the space 1and1 allots my account).–
   1and1 wants me to upgrade to a business package in order to copy my data over.–
   My blog gets only 200-300 hits a week and occasional posts, mostly about medical
   issues. A business account is ridiculous.
 * Does anyone have any ideas on how to get around this crazy limit? Split the database,
   move to another host, move to WP.com or blogger or somesuch? Or??? I’m open to
   all ideas.
 * I can ignore this for now, but eventually I’ll have to upgrade to a newer version
   of WordPress, and the issue will come back.
 * Thanks for any help.
    EdB

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

 *  [WPpremium](https://wordpress.org/support/users/wppremium/)
 * (@wppremium)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/upgrading-blog-database-problem/#post-1452799)
 * I suggest you to change your host. The minimum requirement for for wordpress 
   in MySQL 4.1.2. Do they provide any interface like PHPMyAdmin to dump the SQL
   database?
 *  Thread Starter [edb](https://wordpress.org/support/users/edb/)
 * (@edb)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/upgrading-blog-database-problem/#post-1452865)
 * Yes, they provide PHPMyAdmin, but they have it dialed down to 2048k maximum file
   size. Even in their how to use documentation it shows the file size is 3 or 4x
   higher. 1and1 clearly has manipulated the program to extract more money.
 * Any suggestions on other hosts?
 * EdB
 *  [WPpremium](https://wordpress.org/support/users/wppremium/)
 * (@wppremium)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/upgrading-blog-database-problem/#post-1452880)
 * Many hosting providers provide free web site transfer. Also, most of the hosts
   provide facility to restore database (larger than 2 MB) from PHPMyAdmin or you
   can provide the backup to them. They will restore it for you.
 *  Thread Starter [edb](https://wordpress.org/support/users/edb/)
 * (@edb)
 * [15 years, 8 months ago](https://wordpress.org/support/topic/upgrading-blog-database-problem/#post-1453014)
 * The solution was both easy and ridiculous:
 * 1&1 wouldn’t let me back up the whole file, however I **was** able to port the
   whole site to a wordpress.com hosted blog. So I created one and moved everything
   there, then created a new WP install on my host with the proper database version,
   then copied everything back from the hosted blog. Did some tweaking and cleanup,
   and done.

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

The topic ‘Upgrading blog database problem’ is closed to new replies.

## Tags

 * [1and1](https://wordpress.org/support/topic-tag/1and1/)
 * [database](https://wordpress.org/support/topic-tag/database/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [edb](https://wordpress.org/support/users/edb/)
 * Last activity: [15 years, 8 months ago](https://wordpress.org/support/topic/upgrading-blog-database-problem/#post-1453014)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics