Web Host Mysql 4 vs. WP Mysql 5 Conflict (5 posts)

  1. hottamale
    Posted 8 years ago #

    I created a localhost on my Mac running Mysql 5 and built a large WP site with a plan to move it to my webhost and replace an older html-based site running there. Turns out the webhost is running Mysql 4 and it can't import my Mysql 5 database. Or so they say.

    What are my options? Downgrade to Mysql 4 on localhost and hope I can get that database mounted at the webhost?

    Is there a way to get Mysql 5 to output a Mysql 4 compatible database?

    Or should I look for a new webhost running Mysql 5? My web site gets a fair amount of traffic, so I'm looking for a seamless way to get the new WP web site up and running without any down time.

    Any wisdom greatly appreciated.

  2. MichaelH
    Posted 8 years ago #

    Don't have a MySQL 5 database to check this, but I believe the phpmyAdmin Export process can export to a MySQL 4 database.

    Guess you could always use the WordPress export/import process.

  3. onstagelighting
    Posted 7 years ago #

    I am having the same problem so I have bumped this thread.

    I am try to migrate to a new host but at the moment they only support MYSQL 4. My previous WP install was on MySql5 and when I try to export it, a load of invalid characters appear in the db and the post content. This is usually around unescaped characters but not exclusively.

    I have tried a few different tactics to export/import both the database and the wp installation but the problem won't resolve. My old site is running wp 2.1.3 and I have tried a few different versions for the new site - currently 2.3.3.

    I have also run the ut8 change plug in which has sorted out the old database to utf8, but this has not helped after a new export.
    I have narrowed it down to the MySql4/5 compatibility export.

    Can anyone tell me the best way to arrange and export my data in MYSQL4 mode and import to a new WP install without breaking the characters?

    PS I have partially improved the new site but running the utf8 cleanup plug-in which remove some of the gobbledy gook but it is not really a long term solution.

  4. f1f
    Posted 7 years ago #

    I am also having the same problem - my database is MySQL 5 but the server I'm moving to is MySQL 4 only. What should I do?

  5. f1f
    Posted 7 years ago #

    Ah I've managed to sort this. It turns out in PhpMyAdmin when you export a database you can select to export as MySQL 4 (and earlier versions). I did that, uploaded the new database and that worked.

Topic Closed

This topic has been closed to new replies.

About this Topic