Re: Export database from 64 bit and import in 32 bit
Posted by:
Rick James
Date: January 24, 2015 07:20PM
The data storage format is identical for 32-bit and 64-bit versions.
At worst, you will get a syntax error that can be fixed.
Rarely, datatypes change over time and/or something else changes. So, there are rare cases of dump + load troubles.
Example: Loading into 4.0 will probably croak because the dump probably says "ENGINE=..." but 4.0 only know the old term: "TYPE=...". And I think there is a mysqldump parameter to tell it to use the old syntax.
Probably nothing has ever changed _within_ the same major version (eg, 5.x.zz to 5.x.y).
Subject
Written By
Posted
Re: Export database from 64 bit and import in 32 bit
January 24, 2015 07:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.