/ Register

Want more timely Centmin Mod News Updates?
Become a Member

MariaDB How to properly export from Mysql 5.5 and preserve Vietnamese characters?

Discussion in 'Nginx, PHP-FPM & MariaDB MySQL' started by rdan, Mar 18, 2016.

Previous Thread Next Thread
Loading...
  1. Mar 18, 2016 #1
    rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    1:43 PM
    Mainline
    10.2
    I am migrating some Data from a server with Mysql 5.5.
    Database has default latin1 collation.

    When I import it to MariaDB 10.1 server, Vietnamese characters messed up even if I use the same database collation.

    I even tried:

    mysqldump -uroot -pXXXXXXXX --default-character-set=latin1 DB_name > DB_name.sql
    mysql -uroot -pXXXXXXXX --default-character-set=latin1 DB_name < DB_name.sql


    Still messing up the characters.
    Please advice :/
     
  2. Mar 18, 2016 #2
    pamamolf

    pamamolf Well-Known Member

    4,125
    429
    83
    May 31, 2014
    Ratings:
    +841
    Local Time:
    8:43 AM
    Nginx-1.29.x
    MariaDB 10.6.x
    A simple dump without any parameters and setting the exact same database character set on the new server and then a simple import is always ok for me and i mess always with unicode characters without any issues.....
     
  3. Mar 18, 2016 #3
    rdan

    rdan Well-Known Member

    5,452
    1,418
    113
    May 25, 2014
    Ratings:
    +2,212
    Local Time:
    1:43 PM
    Mainline
    10.2
    Sadly for me that didn't work.
    It messed up Vietnamese Characters.
     
  4. Mar 18, 2016 #4
    Sunka

    Sunka Well-Known Member

    1,150
    325
    83
    Oct 31, 2015
    Pula, Croatia
    Ratings:
    +525
    Local Time:
    7:43 AM
    Nginx 1.17.9
    MariaDB 10.3.22
    Try to set both character set (collation) to same before restoring. On database (new one) and on server (sql)
     
Previous Thread Next Thread
Loading...

.