phpmyadmin: restoring mySQL4 DB into mySQL5 DB

Discussion in 'MySQL' started by micko_escalade, Jul 4, 2007.

0
  1. #1
    Hi,

    everything works fine after I restore mySQL4 DB on FC4
    except that character encoding is not restored correctly,
    If I write new post after restore using characters ie. č, ć....etc they are displayed correctly but the ones from the restore aren't displayed correctly,

    any suggestions?
     
    micko_escalade, Jul 4, 2007 IP
  2. micko_escalade

    micko_escalade Peon

    Messages:
    2
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Problem solved!

    in case some runs into same problem backing up and restoring using command line worked,

    to backup I used mysqldump --opt -u root -p my_db_name > backup.sql
    and to restore I used mysql -u root -p my_db_name < backup.sql
     
    micko_escalade, Jul 5, 2007 IP