Support » Fixing WordPress » Web Host Mysql 4 vs. WP Mysql 5 Conflict

  • 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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • 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.

    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.

    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?

    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.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Web Host Mysql 4 vs. WP Mysql 5 Conflict’ is closed to new replies.