ADO back up full database

[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

[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.

[MOISES]

Thank you.

And what about saving and restoring each table in a txt local file?

All the best,

[MOISES]

Up!

[Armando]

Moises:

Take a look at MySqlDump.exe and MySQL.Exe

Regards

[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

[MOISES]

Up!