FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


I need help! MySQL version ploblem





takashiro
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?
badai
maybe u can use phpmyadmin, export, then import back.
johanfh
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
Josso
Yeah backwards compatibility on MySQL is supposed to be fairly awful - I suggest not trying that. Host your forum on another server perhaps?
kv
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.
Related topics
What are the versions of PhP and MySQL on this server...
mysql and apache problem.
Concerning MySQL version
php can't connect to mysql
Is there any mysql version that supports subquerries or not?
PHP/Mysql - beginner!
Setup php,mysql and others...
MySQL and PHP problem in the future
Wordpress 2.1 "Ella" Upgrading
MySQL Set-up Structure - Help!!!
PHP and MySQL version
Why do I see Server version: 4.0.23-standard-log in MySQL
404 Not Found error was encountered (PLEASE HELP!!!)
PHP and Mysql version on web host to install new moodle
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.