Jump to:

21298 Posts in 5735 Topics by 2603 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, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w

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

    mysqldump Link to this post

    1 September 2010 at 2:11am

    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

    1 September 2010 at 5:23am

    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

    25 October 2010 at 11:42pm

    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
    1675 Posts

    Re: mysqldump Link to this post

    25 October 2010 at 11:46pm

    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/

    819 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.