Issues with mysql and mysqldump

[mackym-dev]

Hi!

I'm hoping for a bit of help getting Wordmove set up on windows 🙏

My set up:

Local
Windows 10
XAMPP
Ruby installed - ruby 2.6.10p210 (2022-04-12 revision 67958) [x64-mingw32]
Wordmove installed 5.2.2
WP-CLI installed 2.7.1

Doctor
C:\xampp\htdocs\forest_retreats_local>wordmove doctor .------------------------. | PSYCHIATRIC | | HELP 5¢ | |________________________| || .-"""--. || || / \.-. || || | ._, \ || || \_/-' '-.,/ ||
|| ( (' )') \ ||
|| /| |\ ||
|| | \ __ / | ||
|| _).,_____,/}/ ||
__||;--''/ ( ||
|\ || (_,\ _/------||
||||_____________________||
|||| |
|||| THE DOCTOR |
||| IS [IN] |
|| ()
|___________________//||\\ //=||=\\ `` `

▬▬ Using Movefile: ./movefile.yml ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ Validating movefile section: global ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

✅  success | Formal validation passed

▬▬ Validating movefile section: local ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

✅  success | Formal validation passed

▬▬ Validating movefile section: staging ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

✅  success | Formal validation passed

▬▬ Validating movefile section: production ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

✅  success | Formal validation passed

▬▬ Using Movefile: ./movefile.yml ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

▬▬ Checking local database commands and connection ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

❌  error | `mysql` command is not in $PATH

❌  error | `mysqldump` command is not in $PATH

❌  error |   We can't connect to the MySQL server using credentials
            specified in the Movefile. Double check them or try
            to debug your system configuration.

            The command used to test was:

            mysql --host=127.0.0.1 --user=root -e'QUIT'


❌  error |   We can't connect to the database using credentials
            specified in the Movefile, or the database does not
            exists. Double check them or try to debug your
            system configuration.

            The command used to test was:

            mysql --host=127.0.0.1 --user=root fr_localhost_050423 -e'QUIT'

▬▬ Checking local wp-cli installation ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

❌  error |   wp-cli is not installed (or not in your $PATH).
          Read http://wp-cli.org/#installing for installation info.

▬▬ Checking rsync ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
'rsync' is not recognized as an internal or external command,
operable program or batch file.
C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/wordmove-5.2.2/lib/wordmove/doctor/rsync.rb:13:in check!': undefined method []' for nil:NilClass (NoMethodError)
from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/wordmove-5.2.2/lib/wordmove/doctor.rb:29:in rsync' from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/wordmove-5.2.2/lib/wordmove/doctor.rb:8:in start'
from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/wordmove-5.2.2/lib/wordmove/cli.rb:17:in doctor' from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/thor-0.20.3/lib/thor/command.rb:27:in run'
from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/thor-0.20.3/lib/thor/invocation.rb:126:in invoke_command' from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/thor-0.20.3/lib/thor.rb:387:in dispatch'
from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/thor-0.20.3/lib/thor/base.rb:466:in start' from C:/Ruby26-x64/lib/ruby/gems/2.6.0/gems/wordmove-5.2.2/exe/wordmove:6:in <top (required)>'
from C:/Ruby26-x64/bin/wordmove:23:in load' from C:/Ruby26-x64/bin/wordmove:23:in

'`

Movefile:
`global:
sql_adapter: "wpcli"

local:
vhost: "http://localhost/forest_retreats_local/"
wordpress_path: "C:/xampp/htdocs/forest_retreats_local" # use an absolute path here

database:
name: "fr_localhost_050423"
user: "root"
password: "" # could be blank, so always use quotes around
host: '127.0.0.1'
# port: '3306'

staging:
vhost: "https://staging.forestretreats.co.uk/"
wordpress_path: "/home/stagingforestret/public_html" # use an absolute path here

database:
name: "stagingforestret_wpsite"
user: "stagingforestret_root"
password: "removed"
host: "localhost"
port: 3308 # Use just in case you have exotic server config
# mysqldump_options: '--max_allowed_packet=1G' # Only available if using SSH
# mysql_options: '--protocol=TCP' # mysql command is used to import db

# paths: # you can customize wordpress internal paths
# wp_content: wp-content
# uploads: wp-content/uploads
# plugins: wp-content/plugins
# mu_plugins: wp-content/mu-plugins
# themes: wp-content/themes
# languages: wp-content/languages

# ssh:
# host: host
# user: user
# password: password # password is optional, will use public keys if available.
# port: 22 # Port is optional
# rsync_options: '--verbose --itemize-changes' # Additional rsync options, optional
# gateway: # Gateway is optional
# host: host
# user: user
# password: password # password is optional, will use public keys if available.

ftp:
user: "macky@staging.forestretreats.co.uk"
password: "removed"
host: "ftp.staging.forestretreats.co.uk"
passive: true
# port: 21 # Port is optional
# scheme: ftps # default ftp. alternative sftp

# hooks: # Remote hooks won't work with FTP
# push:
# before:
# - command: 'echo "do something"'
# where: local
# raise: false # raise is true by default
# after:
# - command: 'echo "do something"'
# where: remote
# pull:
# before:
# - command: 'echo "do something"'
# where: local
# raise: false
# after:
# - command: 'echo "do something"'
# where: remote
#
# forbid:
# push:
# db: false
# plugins: false
# themes: false
# languages: false
# uploads: false
# mu-plugins: false
# pull:
# db: false
# plugins: false
# themes: false
# languages: false
# uploads: false
# mu-plugins: false

production:
vhost: "https://forestretreats.co.uk/"
wordpress_path: "/home/forestretreatsco/public_html" # use an absolute path here

database:
name: "forestretreatsco_frwpsite"
user: "removed"
password: removed
host: "localhost"
port: 3308 # Use just in case you have exotic server config
# mysqldump_options: '--max_allowed_packet=1G' # Only available if using SSH
# mysql_options: '--protocol=TCP' # mysql command is used to import db

exclude:
- '.git/'
- '.gitignore'
- '.gitmodules'
- '.env'
- 'node_modules/'
- 'bin/'
- 'tmp/'
- 'Gemfile'
- 'Movefile'
- 'movefile'
- 'movefile.yml'
- 'movefile.yaml'
- 'wp-config.php'
- 'wp-content/.sql.gz'
- '.orig'

# paths: # you can customize wordpress internal paths
# wp_content: wp-content
# uploads: wp-content/uploads
# plugins: wp-content/plugins
# mu_plugins: wp-content/mu-plugins
# themes: wp-content/themes
# languages: wp-content/languages

# ssh:
# host: host
# user: user
# password: password # password is optional, will use public keys if available.
# port: 22 # Port is optional
# rsync_options: '--verbose --itemize-changes' # Additional rsync options, optional
# gateway: # Gateway is optional
# host: host
# user: user
# password: password # password is optional, will use public keys if available.

ftp:
user: "removed"
password: "removed"
host: "ftp.forestretreats.co.uk"
passive: true
# port: 21 # Port is optional
# scheme: ftps # default ftp. alternative sftp

# hooks: # Remote hooks won't work with FTP
# push:
# before:
# - command: 'echo "do something"'
# where: local
# raise: false # raise is true by default
# after:
# - command: 'echo "do something"'
# where: remote
# pull:
# before:
# - command: 'echo "do something"'
# where: local
# raise: false
# after:
# - command: 'echo "do something"'
# where: remote
#
# forbid:
# push:
# db: false
# plugins: false
# themes: false
# languages: false
# uploads: false
# mu-plugins: false
# pull:
# db: false
# plugins: false
# themes: false
# languages: false
# uploads: false
# mu-plugins: false

# staging: # multiple environments can be specified
# [...]

`

Doctor says mysql and mysqldump are not in $PATH but I have added the bin location here:

Also I can execute mysql commands no problem:
C:\xampp\htdocs\forest_retreats_local>mysql -V mysql Ver 15.1 Distrib 10.4.27-MariaDB, for Win64 (AMD64), source revision 0946c99e7d6f7ac9dfcf3e60dae6ae85161d5ef2

I've tried 'localhost' and '127.0.0.1' as the db host.

This command mysql --host=127.0.0.1 --user=root -e'QUIT' doesn't work (see doctor output), but if I use:

`C:\xampp\htdocs\forest_retreats_local>mysql --host=127.0.0.1 --user=root
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 44
Server version: 10.4.27-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>`

.. the connection seems to work fine. Also 'mysql --host=127.0.0.1 --user=root fr_localhost_050423' works.

I've spent a couple of days trying to get this working as I REALLY want to use Wordmove - any help very much appreciated!