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!