Backup probelm with remote server

Janathan Liaw · Post by **Janathan Liaw** » Mon 13 Jun 2005 06:42

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

Ikar · Post by **Ikar** » Mon 13 Jun 2005 06:52

Please see TMyBackup.Local property description

Janathan Liaw · Post by **Janathan Liaw** » Mon 13 Jun 2005 15:25

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.

Ikar · Post by **Ikar** » Mon 13 Jun 2005 15:30

Use TMyDump instead