Page 1 of 1

Downgrading MySQL 5 to 4 Database

Posted: Fri Dec 12, 2008 4:11 pm
by dhtml12345
Hello!

I have a MySQL 5 database that I'm using for CMSMS.  I would like to change to a Web host that happens to have MySQL 4.  Does anyone know how I might downgrade my CMSMS database?

Thanks a lot!

Re: Downgrading MySQL 5 to 4 Database

Posted: Fri Dec 12, 2008 6:58 pm
by Nullig
You can do an export/import of the db using phpmyadmin, or do a mysqldump and import using phpmyadmin.

Nullig

Re: Downgrading MySQL 5 to 4 Database

Posted: Fri Dec 12, 2008 7:41 pm
by Dee
Nullig wrote: You can do an export/import of the db using phpmyadmin, or do a mysqldump and import using phpmyadmin.
Nullig
It is probably recommended to select SQL compatibility mode "MYSQL40" when exporting the db using phpmyadmin.

Regards,
D