Menu ▾ ▴

#3242 (ok 3.4) XML import doesn't recognise utf8

3.3.9
fixed
Michal Čihař
Data Import (38)
1
2013-06-11
2011-03-13
Anonymous
No

1. When database or table (with data in utf8) is exported as an XML file and later imported via PMS the "multi-byte" characters in utf8 are not correctly imported in MySQL. I tryed this action on my installation and also on demo server (http://wiki.phpmyadmin.net/pma/Demo_server) and got the same result ...
2. Even though the export in XML was done on the same server with rather small DB (10MB) the XML file has to be divided in many parts if you want to import the data back to MySQL via PMA. Probably the PHP and PMA upload and session/thread settings were not correct (the upload limit in php is 32MB and memory limit 128MB, but I can't/don't know how to extend 128MB limit) but there is not an exact help how and what you should set up ...

Discussion

  • Michal Čihař

    Michal Čihař - 2011-03-18
    • assigned_to: nobody --> nijel
     

  • Michal Čihař

    Michal Čihař - 2011-03-18

    This bug was fixed in repository and will be part of a future release; thanks for reporting.

     

  • Michal Čihař

    Michal Čihař - 2011-03-18
    • priority: 5 --> 1
    • summary: XML import doesn't recognise utf8 --> (ok 3.4) XML import doesn't recognise utf8
    • status: open --> open-fixed
     

  • Marc Delisle

    Marc Delisle - 2011-05-11
    • status: open-fixed --> closed-fixed
     

  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed