#927 Export to target version

Tim Lokot

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


  • Michal Čihař

    Michal Čihař - 2006-06-21

    Logged In: YES

    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