Page 1 of 1
ADO back up full database
Posted: Fri Sep 13, 2019 2:44 pm
by MOISES
Hi,
Using ado/FW_ado functions as DBMS management irrespective of MYSQL, MSSQL, etc, is there a way to back up the whole database to a local file?
Thank you
Re: ADO back up full database
Posted: Fri Sep 13, 2019 4:28 pm
by nageswaragunupudi
Backup and Restore are specific to each database. There is no common support in ADO.
For MySql, we can use FWH oCon:Backup(...) and oCon:Restore(...) methods.
Re: ADO back up full database
Posted: Fri Sep 13, 2019 5:01 pm
by MOISES
Thank you.
And what about saving and restoring each table in a txt local file?
All the best,
Re: ADO back up full database
Posted: Mon Sep 16, 2019 6:01 pm
by MOISES
Up!
Re: ADO back up full database
Posted: Mon Sep 16, 2019 6:32 pm
by Armando
Moises:
Take a look at MySqlDump.exe and MySQL.Exe
Regards
Re: ADO back up full database
Posted: Tue Sep 17, 2019 11:53 am
by MOISES
Thank you very much for replying. I am looking for an approach via ADO for MySQL/MSSQL/MarĂa DB, therefore neutral from the point of view of the database.
I think this method exists, but I haven't found its parameters.
Greetings
Re: ADO back up full database
Posted: Wed Sep 18, 2019 7:08 pm
by MOISES
Up!