{"id":1198,"date":"2017-10-14T10:07:04","date_gmt":"2017-10-14T01:07:04","guid":{"rendered":"http:\/\/blue-bear.jp\/kb\/?p=1198"},"modified":"2017-10-14T10:07:04","modified_gmt":"2017-10-14T01:07:04","slug":"wordpress-how-to-migrate-mysql-for-wordpress-from-local-to-aws-rds","status":"publish","type":"post","link":"https:\/\/blue-bear.jp\/kb\/wordpress-how-to-migrate-mysql-for-wordpress-from-local-to-aws-rds\/","title":{"rendered":"[wordpress] How to migrate mysql for wordpress from local to AWS RDS"},"content":{"rendered":"

How to migrate mysql for wordpress from local to AWS RDS, are below<\/p>\n

    \n
  1. Create mysql RDS (Instance name, tablename (wordpress,etc) , ID , Password , etc)<\/li>\n
  2. Create security Group for allowing mysql tcp 3306 port and attach this to RDS<\/li>\n
  3. Note RDS Endpoint name<\/li>\n<\/ol>\n

    \"\u30b9\u30af\u30ea\u30fc\u30f3\u30b7\u30e7\u30c3\u30c8<\/p>\n

    4. Export local mysql data by mysqldump command<\/p>\n

    mysqldump -u root -p [table\u540d] > backup.sql<\/pre>\n
    5. Import exported date into RDS by mysql command<\/p>\n
    mysql -u [RDS table username] -p -h [RDS Endpoint] -D [RDS table Name] < backup.sql<\/pre>\n
    6. Modify wp-config.php DB access portion for RDS (endpoint name, table name , ID , password)<\/p>\n
    \"migrate-database-rds-17-49701cf1\"<\/p>\n
     <\/p>\n
    For rollback to local, should do reverse task<\/p>\n
     <\/p>\n
    Memo :<\/h2>\n
    When migrate to RDS, disable local mysql.<\/p>\n
    when\u00a0rollback to local, should do enable mysql service at local<\/p>\n
     <\/p>\n
    Can’t connect to local MySQL server through socket ‘\/tmp\/mysql.sock\u00a0 Error<\/h3>\n
    when access to local mysql, below error was happened and can’t access to mysql<\/p>\n
    Can't connect to local MySQL server through socket '\/tmp\/mysql.sock<\/pre>\n
     <\/p>\n
    Eventually, forgot that had disabled mysql service at bitnami by renaming “\/opt\/bitnami\/mysql\/scripts\/ctl.sh” to “\/opt\/bitnami\/mysql\/scripts\/ctl.sh.disable”<\/p>\n
     <\/p>\n
    When same error is happened, no mysql running is suspected, then you should check mysql running status by below command<\/p>\n
    ps aux | grep mysql<\/pre>\n
     <\/p>\n
    to run mysql at bitnami, you should run below command<\/p>\n
    sudo \/opt\/bitnami\/ctlscript.sh stop mysql<\/pre>\n
     <\/p>\n
    when you run command but no response, Check existing “\/opt\/bitnami\/mysql\/scripts\/ctl.sh”<\/p>\n
    if no and found another name file, you should re-name to original name “\/opt\/bitnami\/mysql\/scripts\/ctl.sh”<\/p>\n","protected":false},"excerpt":{"rendered":"
    How to migrate mysql<\/p>\n","protected":false},"author":1,"featured_media":1196,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,7],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/1198"}],"collection":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/comments?post=1198"}],"version-history":[{"count":1,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/1198\/revisions"}],"predecessor-version":[{"id":1199,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/posts\/1198\/revisions\/1199"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media\/1196"}],"wp:attachment":[{"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/media?parent=1198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/categories?post=1198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blue-bear.jp\/kb\/wp-json\/wp\/v2\/tags?post=1198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}