PHP Classes

Issue: missing MySQL Client locally

Recommend this page to a friend!

      PHP MySQL Query CSV Export and Download  >  All threads  >  Issue: missing MySQL Client locally  >  (Un) Subscribe thread alerts  
Subject:Issue: missing MySQL Client locally
Summary:Issue: missing MySQL Client locally xampp
Messages:3
Author:Alfredo Alfaro
Date:2024-07-28 01:20:23
 

  1. Issue: missing MySQL Client locally   Reply   Report abuse  
Picture of Alfredo Alfaro Alfredo Alfaro - 2024-07-28 01:20:23
Hi, I am trying using the class with xampp but cannot make it work

have the following error:
Issue: missing MySQL Client locally

private $mysqlClientLoc = 'C:/xampp/mysql/bin/mysql.exe';

  2. Re: Issue: missing MySQL Client locally   Reply   Report abuse  
Picture of Ramesh Narayan Jangid Ramesh Narayan Jangid - 2024-07-28 06:25:41 - In reply to message 1 from Alfredo Alfaro
This application won't work on Windows OS.

Because the commands I am generating to extract the data are compatible on linux environment only.

  3. Re: Issue: missing MySQL Client locally   Reply   Report abuse  
Picture of Ramesh Narayan Jangid Ramesh Narayan Jangid - 2024-10-18 07:43:50 - In reply to message 1 from Alfredo Alfaro
I would recommend as below.

private $mysqlClientLoc = 'mysql';
This should catch the installed mysql in the command line.

and remove below line
. '| sed -e \'s/"/""/g ; s/\t/","/g ; s/^/"/g ; s/$/"/g\''

Do check the semicolon for the string.

This should give CSV in tab separated format instead of comma.