Jump to:

22979 Posts in 11815 Topics by 2826 members

General Questions

SilverStripe Forums » General Questions » mysqldump

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, biapar, Willr, Ingo, swaiba, simon_w

Page: 1
Go to End
Author Topic: 921 Views
  • Mario...
    Avatar
    Community Member
    14 Posts

    mysqldump Link to this post

    When I use mysqldump and then restore the character encoding is screwed up. Any idea hows?

  • dompie
    Avatar
    Community Member
    88 Posts

    Re: mysqldump Link to this post

    You can specify a character set encoding for dumping mysql data. by default it is utf8 (at least on my system). this might be not the encoding silverstripe created your tables with.

  • Mario...
    Avatar
    Community Member
    14 Posts

    Re: mysqldump Link to this post

    Mysql has a double encoding problem, screws up the characters of you upgrade and use:
    MySQLDatabase::set_connection_charset('utf8'); Which I hadn't tried to remove.

  • swaiba
    Avatar
    Forum Moderator
    1769 Posts

    Re: mysqldump Link to this post

    add 'SET sql_mode = 'ANSI';' to the top of the script before running it?

    also I'd suggest using... http://www.silverstripe.org/database-plumber-module/

    921 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.