MySQL Dump Error

MySQL Dump Error

We use MySQL Dump to do backups This error is telling you that it can’t copy the mysqldump.exe file from mysqlRootFolder\bin to c:\Program Files\ArrowPOS folder. When ArrowPos starts up it looks at what version of ArrowPos that ArrowServer is running and copies mysqldump file to the ArrowPos folder. 


To determine the sql directory run one of the 3 queries below. 

select @@BaseDir

or

SELECT Variable_value as BaseDir FROM information_schema.GLOBAL_VARIABLES G where g.variable_name = 'basedir'

or

SELECT Variable_value as BaseDir FROM performance_schema.GLOBAL_VARIABLES G where g.variable_name = 'basedir'


Copy the the mysqldump.exe file from the DB station to the station generating the dump error. Also be sure to check permissions on that station.

Verify if its successful by attempting to create an arrowPOS schema backup in db functions and check the file size of the backup. Broken backups will typically be less than 2kb.