###環境
Mac OS High Sierra
エックスサーバー
vagrant 2.0.1
vccw 3.13.0
###前提・実現したいこと
Wordmoveを使って本番環境のWordpressサイトをローカル環境に同期したい
###発生している問題・エラーメッセージ
▬▬ ✓ Pulling Database ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
local | mysqldump --host=localhost --user=wordpress --password=wordpress --default-character-set=utf8 --result-file="/var/www/html/wp-content/local-backup-1514468890.sql" wordpress
mysqldump: [Warning] Using a password on the command line interface can be insecure.
gzip --best --force "/var/www/html/wp-content/local-backup-1514468890.sql"
local | gzip --best --force "/var/www/html/wp-content/local-backup-1514468890.sql"
remote | mysqldump --host=XXXXX.xserver.jp --user=XXXXX --password=XXXXX --default-character-set=utf8 --result-file="/home/XXXXX/XXXXX.com/public_html/wp-content/dump.sql" XXXXX
Text will be echoed in the clear. Please install the HighLine or Termios libraries to suppress echoed text.
Enter passphrase for /home/vagrant/.ssh/id_rsa:XXXXX
gzip --best --force "/home/XXXXX/XXXXX.com/public_html/wp-content/dump.sql"
remote | gzip --best --force "/home/XXXXX/XXXXX.com/public_html/wp-content/dump.sql"
remote | get: /home/XXXXX/XXXXX.com/public_html/wp-content/dump.sql.gz /var/www/html/wp-content/dump.sql.gz
remote | delete: /home/XXXXX/XXXXX.com/public_html/wp-content/dump.sql.gz
gzip -d --force "/var/www/html/wp-content/dump.sql.gz"
local | gzip -d --force "/var/www/html/wp-content/dump.sql.gz"
local | adapt dump
/home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/sql_adapter.rb:44:in gsub!': invalid byte sequence in UTF-8 (ArgumentError) from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/sql_adapter.rb:44:in
serialized_replace!'
from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/sql_adapter.rb:36:in replace_field!' from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/sql_adapter.rb:25:in
replace_vhost!'
from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/sql_adapter.rb:17:in adapt!' from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/deployer/base.rb:168:in
adapt_sql'
from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/deployer/ssh.rb:39:in pull_db' from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/cli.rb:69:in
block in pull'
from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/cli.rb:37:in block in handle_options' from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/cli.rb:36:in
each'
from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/cli.rb:36:in handle_options' from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/lib/wordmove/cli.rb:68:in
pull'
from /home/vagrant/.gem/ruby/2.3.0/gems/thor-0.19.4/lib/thor/command.rb:27:in run' from /home/vagrant/.gem/ruby/2.3.0/gems/thor-0.19.4/lib/thor/invocation.rb:126:in
invoke_command'
from /home/vagrant/.gem/ruby/2.3.0/gems/thor-0.19.4/lib/thor.rb:369:in dispatch' from /home/vagrant/.gem/ruby/2.3.0/gems/thor-0.19.4/lib/thor/base.rb:444:in
start'
from /home/vagrant/.gem/ruby/2.3.0/gems/wordmove-2.0.0/exe/wordmove:6:in <top (required)>' from /home/vagrant/.gem/ruby/2.3.0/bin/wordmove:23:in
load'
from /home/vagrant/.gem/ruby/2.3.0/bin/wordmove:23:in `<main>'
下記Movefile.ymlの内容です。
local:
vhost: "http://設定したローカルのホスト名"
wordpress_path: "/var/www/" # use an absolute path here
database:
name: "wordpress"
user: "wordpress"
password: "wordpress"
host: "localhost"
charset: "utf8"
production:
vhost: "http://本番環境のドメイン"
wordpress_path: "/home/サーバーID/本番環境のドメイン/public_html" # use an absolute path here
database:
name: "本番環境のDB名"
user: "本番環境のDBユーザー名"
password: "本番環境のDBパスワード"
host: "本番環境のDBホスト名"
charset: "utf8"
exclude:
".git/"
".gitignore"
".sass-cache/"
"bin/"
"tmp/"
"Gemfile"
"Movefile"
"wp-config.php"
"wp-content/*.sql"
".htaccess"
ssh:
host: "本番環境ホスト名(初期ドメイン)"
user: "ユーザー名"
port: 10022
rsync_options: "--verbose"
バッドをするには、ログインかつ
こちらの条件を満たす必要があります。