Is there any effect if i interchange MySQL/MariaDB .frm files from dbs with similar structure on any CRUD operation?

note: the different is some tables have different fields, whether its existence, datatype, default value or any others.


The .frm drives the parsing of rows. So if the datatype or number of columns changes, it seems very likely that the rows cannot be read.

Consider using a VIEW to "change" the structure of a table.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.