Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MySQLDump.exe
Message
De
24/05/2007 16:11:20
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Novell 5.x
Database:
MySQL
Divers
Thread ID:
01228295
Message ID:
01228308
Vues:
16
This message has been marked as the solution to the initial question of the thread.
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform