Devart Forums

In MyBackup.pas (MyDAC 3.50.0.20), Line 492, your code specify

SELECT ' + GetFieldsString + ' INTO OUTFILE "' + FileName

which if I execute your MyBackup component at remote server with the property Path= C:\BackupDir, Your statement will result the
MySQL server to backup the files into its locat C:\BackupDir (if there is one). This is not the intended effect. By settng the Path = C:\BackupDIr, one would expect MyBackup to places the backup files into the local client PC C:\BackupDir.

I would suggest to have a look into the code from MySQL Administrator where the backup is rather well done.

Jonathan Liaw

Please see TMyBackup.Local property description

Hi Ikar,
I think TMyBackup.Local only affect the Restore operation rather than the Backup process. I actually want to backup the server data files into my local PC directory, could you tell me a way of doing it.

Use TMyDump instead