Backwards compatability with MySQL 5.0.21 1

[ChrisRChamberlain]

Hi all

As a MySQL newbie I want to do some development work on a local server using Apache/MySQL version 5.0.21 and later upload the databases to a web server running MySQL version 4.0.20 or MySQL version 4.1.15 on a linux OS.

I assume converting 5.0.21 to 4.x.xx would involve exporting and importing the data and the question is - will MySQL version 5.0.21 read/write MySQL version 4.x.xx data?

TIA

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

If you use mysqldump (which produces text files containing the SQL necessary to recreate and populate the tables), you should be OK.

 

[ChrisRChamberlain]

TonyGroves

Thanks for your reply and the suggestion about mysqldump.

Will MySQL version 5.0.21 read/write MySQL version 4.x.xx data(abases)?

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com

 

[TonyGroves]

Exporting from 5.0 via mysqldump and then importing into 4.x via mysql should work, as the file format is version-neutral.

It might be possible to copy table files directly (after stopping both servers) from 5.0 to 4.x, depending on whether there have been any file-format changes in the meantime, but I wouldn't rely on it.

 

[TonyGroves]

Just to clarify about mysqldump - if your 5.0 tables are using features that are not available in the older version, then you will have problems with "syntax errors" when you try to import into 4.x.

 

[ChrisRChamberlain]

The 5.0 tables will be built as per 4.x.

Thanks again

FAQ184-2483 - answering getting answered.​

Chris
PDFcommander^tm.net
PDFcommander^tm.com