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.