>Hello,
>
>I try to make a backup from an MySQL database from within a VFP application.
>
>I tried the following command so far:
>
>! /N c:\Projects\MyApp\MySQL\Bin\MySQLDump.exe --user=root --port=3307 MyDatabase > c:\test2.sql
>
>
>This line works in the DOS commandline. but when executing from VFP, MySQL returns an error
>
>Couldn't find table ">"
>
>So it mixes up the ">" character and assumes it is a table, although running from DOS it does it well.
>
>Any ideas what I could do, or using another backup program?
1. Create a batch file which contains your backup command (e.g. STRTOFILE( ))
lcBackupCommand = "c:\Projects\MyApp\MySQL\Bin\MySQLDump.exe --user=root --port=3307 MyDatabase > c:\test2.sql"
=STRTOFILE( lcBackupCommand, "Backup.CMD" )
2. Run that batch file (rather than the command itself) from VFP
! /N Backup.CMD
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up