Creating a MySQL dump that is compatible with 4.0.x and 4.1.x

Discussion in 'MySQL' started by Skribblez, Apr 28, 2006.

0
  1. #1
    Hi, currently my host is running MySQL 4.1.18-standard and I'm looking into starting an arcade script business very soon, probably in the next few days, I have the arcade script ready, and just waiting on the web design to be coded. The problem is, the script didn't come with an installer, the users have to edit the config file and manually import the mysql backup into their database through phpMyAdmin.

    I created the backup on my host which is running MySQL 4.1.18-standard. I don't think the backup will work if it was to be restored on a server running MySQL 4.1.x :confused: Is there any way, in the export tab in phpMyAdmin, or anywhere else, where I can create a MySQL dump/backup that would be compatible with both 4.1.x and 4.0.x of MySQL?

    I highly appreciate any and all help on this! :)
     
    Skribblez, Apr 28, 2006 IP
  2. exam

    exam Peon

    Messages:
    2,434
    Likes Received:
    120
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Newer versions of PhpMyAdmin have a SQL export compatibility option when exporting. Choose MYSQL40
     
    exam, Apr 28, 2006 IP
  3. Skribblez

    Skribblez Notable Member

    Messages:
    5,939
    Likes Received:
    208
    Best Answers:
    0
    Trophy Points:
    280
    #3
    Would that make it compatible for both 4.0.x and 4.1.x or just 4.0.x?

    Thanks a bunch! I owe you one :)
     
    Skribblez, Apr 28, 2006 IP
  4. exam

    exam Peon

    Messages:
    2,434
    Likes Received:
    120
    Best Answers:
    0
    Trophy Points:
    0
    #4
    It'll still be compatible with both, but I think it basically removes the collation/charset information the 4.0.x doesn't use. So when you go to import into a server running 4.1, and that database's default charset is different you might run into some problems.
     
    exam, Apr 28, 2006 IP