Upgrading blog database problem

  • Resolved edb

    (@edb)


    16 years ago

    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

    (@wppremium)

    16 years ago

    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

    (@edb)

    16 years ago

    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

    (@wppremium)

    16 years ago

    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

    (@edb)

    15 years, 6 months ago

    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.