MySQLã®VPã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã¨SPIDERã¹ãã¬ã¼ã¸ã¨ã³ã¸ã³ã使ã£ã¦ãä»»æã®ãã¼ãã«ãå¥ãã¹ãã®MySQLã«ç°¡åã«ç§»è¡ããã¹ã¯ãªãããæ¸ãã¾ããã â»ãã ãPRIMARY KEYããããã®ã«éã VPã¨SPIDERã使ã£ã¦ä»»æã®ãã¼ãã«ãå¥ãã¹ãã«ç§»è¡ãã â Gistã«ç½®ãã¦ããã¹ã¯ãªãããè½ã¨ãã¦ãã¦å®è¡æ¨©éãä»ä¸ãã¦ããã wget http://gist.github.com/raw/571569/cb624c24fac767188b4ee9e4925d3f7bfd4dc443/gistfile1.pl -O mygrate_to chmod +x mygrate_to移è¡å ãã¹ãã«ç©ºã®ãã¼ãã«ãã¤ããã mysqldump -u kamipo -h old-db-host --opt --no-data old_db table1 table2 table3 | mysql
{{#tags}}- {{label}}
{{/tags}}