I once used mySQL 5 on my website. Now I need to convert the database to mySQL 4, or the database can't be input. How to do it?
I need help! MySQL version ploblem
maybe u can use phpmyadmin, export, then import back.
I googled a bit for you and found just what I guessed: it's dangerous to try to convert them. It's a lot easyer to just find someone with a 5-server (or install one, maybe with a livecd or small linux), copy the datafiles in there and then dump them with mysqldump, wich has an option for backwards compatibility. That dump can be imported in your mysql 4 server.
Good luck!
JohanFH
Good luck!
JohanFH
Yeah backwards compatibility on MySQL is supposed to be fairly awful - I suggest not trying that. Host your forum on another server perhaps?
One of the options is to get odbc driver for mysql and use ms access to import/export data from one version to other. Or use "mysqldump" command on mysql5 db to generate sql statements and then run it in your mysql4 database to load the data.
 |