Backup probelm with remote server

Backup probelm with remote server

Postby 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
Janathan Liaw
 

Postby Ikar » Mon 13 Jun 2005 06:52

Please see TMyBackup.Local property description
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Backup probelm with remote server

Postby 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.
Janathan Liaw
 

Postby Ikar » Mon 13 Jun 2005 15:30

Use TMyDump instead
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components