env: mysql: No such file or directory after `wp import`

wordpress mamp-pro wp-cli
user2753924 picture user2753924 · Jun 8, 2017 · Viewed 7.2k times · Source

I'm trying to import a database locally using wp db import databasename.sql but I get the following error: env: mysql: No such file or directory. Can anyone tell me how to resolve this?

Answer

5tormTrooper picture 5tormTrooper · Jul 2, 2017

The above didn't help me. I fixed it by adding this to my .bash_profile:

export PATH=$PATH:/Applications/MAMP/Library/bin/

Related questions

Access denied for user 'root@localhost' (using password:NO)

I'm new to MySQL, I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with Web Platform Installer which is provided by Microsoft. I never set a root password for MySQL and in the …

Read More
Create a folder if it doesn't already exist

I've run into a few cases with WordPress installs with Bluehost where I've encountered errors with my WordPress theme because the uploads folder wp-content/uploads was not present. Apparently the Bluehost cPanel WordPress installer does not create this folder, though …

Read More
Correct file permissions for WordPress

I've had a look over here but didn't find any details on the best file permissions. I also took a look at some of WordPress's form's questions over here too but anybody that suggests 777 obviously needs a little lesson in …

Read More