Mysql UTF8 problem - getting dump file with non-english content

Discussion in 'MySQL' started by arthur.x, Jul 9, 2009.

Thread Status:
Not open for further replies.
0
  1. #1
    I need to make backup of my database with both - English and non-English content.

    phpmyadmin spoils all non-English data.
    mysqldump command do same :(

    mysqldump -u USER -pPASSWORD --default-character-set=utf8 DATABASE -r dump.sql

    does anybody know how to make a dump file when you have database in UTF8?
     
    arthur.x, Jul 9, 2009 IP
  2. arthur.x

    arthur.x Banned

    Messages:
    568
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #2
    thank you all, guys, for very helpfull replies.
     
    arthur.x, Jul 9, 2009 IP
Thread Status:
Not open for further replies.