#927 Export to target version

out-of-date
nobody
5
2013-06-11
2006-06-19
Tim Lokot
No

I do a lot of work exporting and importing data
between various versions of MySQL. Currently when
you export the data from say a MySQL 4.1 or 5.0, and
try and import that into MySQL 4.0, there are errors
in the dump syntax because phpMyAdmin assumes the
import server is running the same version of MySQL as
the export server.

The primary issues I consistenly come across is the
export setting flags like TIMESTAMP columns
defaulting to CURRENT_TIMESTAMP, which doesn't exist
under MySQL 4.0, nor does setting the default
charater set to latin1. I have to manually clean the
dump file every time before I can import it.

Can we have another option on the export interface
for listing compatibility versions? eg. Export as
compatible with version <= 4.0.x, >= 4.1, etc

This would save a lot time researching on my part to
figure out where all the differences are in the dump
formats.

Discussion

  • Michal Čihař
    Michal Čihař
    2006-06-21

    Logged In: YES
    user_id=192186

    There alredy is SQL compatibility choice on export page (on
    MySQL versions which do support this).

     
  • Michal Čihař
    Michal Čihař
    2006-06-21

    • status: open --> closed-out-of-date
     
  • Michal Čihař
    Michal Čihař
    2013-06-11

    • Status: closed-out-of-date --> out-of-date