MySQL Migration 4.1 to 4.0 help needed

Discussion in 'MySQL' started by donnareed, Jun 23, 2006.

0
  1. #1
    Can anyone give me some direction on how best to go about this?

    I am running a big Drupal site on Host B, which uses MySql 4.1.19. Host B sucks and I want to move to Host A. Except they are running MySql 4.0.27

    How can I get my database to work? I tried using dbase from Host B on Host A and am getting syntax errors, preventing the tables from loading.

    Have no idea what to do.

    Is there any way I can do this using phpMyAdmin, or do I need Shell access?
     
    donnareed, Jun 23, 2006 IP
  2. iconv

    iconv Well-Known Member

    Messages:
    189
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    108
    #2
    If you're not using non-default character sets and/or collations you can probably get away with just deleting the 'DEFAULT CHARSET=latin1 ' bit in your favorite text editor for all occurrences in the dump file, and then load.

    Or you could mysql dump the db with --compatibility=mysql40, but I'm not sure if phpAdmin supports that.
     
    iconv, Jun 25, 2006 IP