1

I am getting an error with the Wordpress WP-DBManager Plugin:

MYSQL dump path does NOT exist. Please check your mysqldump path under DB Options. 
If uncertain, contact your server administrator.

MYSQL path does NOT exist. Please check your mysql path under DB Options. 
If uncertain, contact your server administrator.

IT Server administrator doesn't know what to do. So I have referred to this article.

I am running AWS, Ubuntu LAMP stack - mysql 5.6, php7.0

I have checked /usr/bin and no mysqldump or mysql folder.

In the php.ini file there is this line ;open_basedir =

Do I create mysqldump and mysql folders? And set open_basedir to open_basedir = /usr/bin/?

Or based on that article there were modules to add - <IfModule sapi_apache2.c>. I could not find the httpd.conf file. Where would I find this file? Or do I create the file?

Zanna
  • 70,465
RRowan
  • 133
  • 7
  • Are you sure it is Ubuntu LAMP stack or it is something like as XAMPP?
  • You can use which mysql (also locate mysql or whereis mysql) to find it.
  • mysqldump is a part of mysql-client package: sudo apt install mysql-client / sudo apt install mysql-client-5.6.
  • Please do not create any folders or files under /usr/bin if you don't know what exactly doing.
  • Within nowadays Ubuntu's versions equivalent of httpd.conf is the file /etc/apache2/apache2.conf.
    • – pa4080 Mar 28 '17 at 08:39
  • Differences between /bin, /sbin, /usr/bin, /usr/sbin, /usr/local/bin, /usr/local/sbin – pa4080 Mar 28 '17 at 08:43
  • Hi there thanks for the feedback. I am running a vagrant/vbox locally with same specs for dev. The folders /usr/bin/mysqldump and mulitple other mysql folders are there. When I type in mysql -v i get this: The program 'mysql' can be found in the following packages:
    • mysql-client-core-5.5
    • mariadb-client-core-5.5
    • mysql-client-core-5.6
    • percona-xtradb-cluster-client-5.5

    Try: sudo apt-get install

    – RRowan Mar 28 '17 at 22:29
  • locate mysql gives me a bunch of folder locations, none of which are /usr/bin – RRowan Mar 28 '17 at 22:29
  • Should I install mysql-client-core-5.6 ? or just sudo apt install mysql-client - and this will get the latest? I am wondering if this will cause any issues if I do this? i.e website crash? I assume not, but just want to make sure – RRowan Mar 28 '17 at 22:37
  • Thanks Spas Spasov installing mysql-client worked sudo apt install mysql-client ! – RRowan Mar 29 '17 at 00:03