I am going to move an account from a server running MySQL 5.x to another server running MySQL 4.1.x - will this be compatible ? I mean since we are moving from a higher version to a lower version, will there be any problems ? BTW, I will be using cPanel migration for this transfer.
mysqldump --compatible=mysql40 -u user -p mydatabase > mydatabasedump.sql
Just a doubt, should it be --compatible=mysql40 or --compatible=mysql41 ? And should I be running the command in the old server (with MySQL 5.x) and then transfer the account using cPanel migration utility ? Or can the command be run after transferring it to the new server also (i.e., from the server running MySQL 4.1.x) ?