Professional Web Applications Themes

Convering mySQL 5 to mySQL 4 - tool available? - MySQL

Does anyone know of any tools that can convert a mySQL5 db to mySQL 4? Upgrading to mySQL 5 is not an option. Thanks...

  1. #1

    Default Convering mySQL 5 to mySQL 4 - tool available?

    Does anyone know of any tools that can convert a mySQL5 db to mySQL 4?
    Upgrading to mySQL 5 is not an option.

    Thanks

    javajoe74@gmail.com Guest

  2. #2

    Default Re: Convering mySQL 5 to mySQL 4 - tool available?

    com wrote: 

    mysqldump --compatible=mysql40 should get you on-track.

    --
    Chad Hanna
    Systems Developer FamilyHistoryOnline www.familyhistoryonline.net
    FreeBSD Apache MySQL Perl mod_perl PHP
    Chad Guest

  3. #3

    Default Re: Convering mySQL 5 to mySQL 4 - tool available?

    HIiChad,

    Thank you so mucho for your reply. I assume I need to run that command
    from my mysql server command line - but unfortunately, I dont have
    access to the actual database.

    I received the dump (in mysql5) from my hosting company, so I can
    restore my site (phpBB). So I have only the dump file (file.sql.gz) to
    work with. Do you know of any tools I can download that would convert
    this?

    Thanks again......
    Joseph


    Chad Hanna wrote: 
    >
    > mysqldump --compatible=mysql40 should get you on-track.
    >
    > --
    > Chad Hanna
    > Systems Developer FamilyHistoryOnline www.familyhistoryonline.net
    > FreeBSD Apache MySQL Perl mod_perl PHP[/ref]

    javajoe74@gmail.com Guest

  4. #4

    Default Re: Convering mySQL 5 to mySQL 4 - tool available?

    com wrote: 
    >> mysqldump --compatible=mysql40 should get you on-track.
    >>[/ref]
    > HIiChad,
    >
    > Thank you so mucho for your reply. I assume I need to run that command
    > from my mysql server command line - but unfortunately, I dont have
    > access to the actual database.
    >
    > I received the dump (in mysql5) from my hosting company, so I can
    > restore my site (phpBB). So I have only the dump file (file.sql.gz) to
    > work with. Do you know of any tools I can download that would convert
    > this?
    >
    > Thanks again......
    > Joseph
    >
    >[/ref]

    Simple solution, set up a MySQL 5 server on a local computer, load it
    the dump file and then redump it as I suggested.

    Second solution, edit the SQL syntax in the file, perhaps with sed, awk,
    perl or similar script. Changing things like CREATE ... ENGINE ... to
    CREATE ... TYPE .. (Not sure of the syntax differences - I'd look at the
    change notes between the two versions on the MySQL web site - and maybe
    not get it right first time.) You obviously don't want to change all
    occurrences of ENGINE in case someone's mentioned it in a message.

    Good luck,

    Chad

    --
    Chad Hanna
    Systems Developer FamilyHistoryOnline www.familyhistoryonline.net
    FreeBSD Apache MySQL Perl mod_perl PHP
    Chad Guest

  5. #5

    Default Re: Convering mySQL 5 to mySQL 4 - tool available?

    Hey Chad,

    Thanks for the suggestions, I'll give them a try.

    Joseph

    Chad Hanna wrote: 
    > > HIiChad,
    > >
    > > Thank you so mucho for your reply. I assume I need to run that command
    > > from my mysql server command line - but unfortunately, I dont have
    > > access to the actual database.
    > >
    > > I received the dump (in mysql5) from my hosting company, so I can
    > > restore my site (phpBB). So I have only the dump file (file.sql.gz) to
    > > work with. Do you know of any tools I can download that would convert
    > > this?
    > >
    > > Thanks again......
    > > Joseph
    > >
    > >[/ref]
    >
    > Simple solution, set up a MySQL 5 server on a local computer, load it
    > the dump file and then redump it as I suggested.
    >
    > Second solution, edit the SQL syntax in the file, perhaps with sed, awk,
    > perl or similar script. Changing things like CREATE ... ENGINE ... to
    > CREATE ... TYPE .. (Not sure of the syntax differences - I'd look at the
    > change notes between the two versions on the MySQL web site - and maybe
    > not get it right first time.) You obviously don't want to change all
    > occurrences of ENGINE in case someone's mentioned it in a message.
    >
    > Good luck,
    >
    > Chad
    >
    > --
    > Chad Hanna
    > Systems Developer FamilyHistoryOnline www.familyhistoryonline.net
    > FreeBSD Apache MySQL Perl mod_perl PHP[/ref]

    javajoe74@gmail.com Guest

Similar Threads

  1. Replies: 2
    Last Post: February 14th, 10:54 AM
  2. Replies: 0
    Last Post: January 29th, 02:03 PM
  3. MySQL Query Tool for php
    By Bob in forum PHP Development
    Replies: 5
    Last Post: October 20th, 01:30 PM
  4. (ANN) FMP_MYSQL Tool - Convert your Filemaker db to MySql
    By Le Nomade.Com in forum FileMaker
    Replies: 0
    Last Post: July 31st, 01:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139