Mysql manualy started

Gilmichel · August 20, 2018, 1:03pm

Hi,

Is it possible, (and so how to), to start Mysql server manually for ExeOutPut ?

Thank-you,
Gilbert

gdgsupport · August 23, 2018, 10:00pm

Sure, use this HEScript code:

var
 ST: string;
begin
 ST := IncludeTrailingBackslash(ExtractFilePath(GetGlobalVar("HEPublicationFile","")));
 RunAProgram(ST + "mysql\bin\mysqld.exe", "--defaults-file=mysql\my.ini --standalone ", ST, false, SW_HIDE);
end;

Gilmichel · August 28, 2018, 4:18pm

Thank-you, I am going to try right now !

What about closing mysql connection manullay ?

Gilmichel · August 28, 2018, 4:41pm

It’s working, now I only need the closing HEScript code please !

gdgsupport · August 29, 2018, 9:21pm

ST := IncludeTrailingBackslash(ExtractFilePath(GetGlobalVar("HEPublicationFile","")));
SP := "ROOTPASSWORD";
RunAProgram(ST + "mysql\bin\mysqladmin.exe", "shutdown -u root -p" + SP, ST, false, SW_HIDE);

Replace ROOTPASSWORD by corresponding value.

Gilmichel · August 30, 2018, 11:33am

It works to, but when i try to start mysql again it doesn’t work !

gdgsupport · August 31, 2018, 6:54pm

Strange. Have you checked that after running the 2nd code, the mysqld.exe daemon process is closed?

Gilmichel · September 1, 2018, 7:20pm

Yes, it is closed !

gdgsupport · September 2, 2018, 7:56am

Change the start code to:

IncludeTrailingBackslash(ExtractFilePath(GetGlobalVar(“HEPublicationFile”,""))); RunAProgram(ST + “mysql\bin\mysqld.exe”, "–defaults-file=mysql\my.ini --standalone ", ST, false, SW_SHOWNORMAL); end;

and see if there is any error displayed when you start MySQL.

Gilmichel · September 2, 2018, 5:04pm

Error in script:
Unknow identifier or variable is not declared: ‘SW_SHOW’

gdgsupport · September 5, 2018, 2:58pm

Try SW_SHOWNORMAL instead

Gilmichel · September 6, 2018, 11:51am

First time start, dos windows displayed.
Second time, after closing mysql, doen’t show nothing !

Thank-you anyway !

Kaizerx · October 2, 2019, 4:00am

same problem here sir.

Kaizerx · October 3, 2019, 5:10am

Is there now an update for this solution sir? b4, i dont have the type of problem like this until i adopt exeouput 2019. THe shutdown hescript code work! . but for start hescript code for mysql doesnt work.

to make it work i have to run the wamp server to run the database. please need for a salvation.

gdgsupport · October 3, 2019, 10:27pm

You said you have a problem restarting the server one more time?

Kaizerx · October 4, 2019, 5:46am

yeah even if i check or uncheck the

still having the error. even when uncheck and manually operate using hescript. The Shutdown hescript work! but start script doesn’t work!. even though it has a blink appearance of cmd( maybe its the mysqld).

gdgsupport · October 7, 2019, 10:49pm

That means the server had a fault for restarting. Please check the logs in the “mysql” subfolder.