FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour ADO back up full database
Posts: 838
Joined: Wed Aug 22, 2007 10:09 AM

ADO back up full database

Posted: Fri Sep 13, 2019 02:44 PM

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

Saludos / Regards,



FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM

Re: ADO back up full database

Posted: Fri Sep 13, 2019 04:28 PM

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.

Regards



G. N. Rao.

Hyderabad, India
Posts: 838
Joined: Wed Aug 22, 2007 10:09 AM

Re: ADO back up full database

Posted: Fri Sep 13, 2019 05:01 PM

Thank you.

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

All the best,

Saludos / Regards,



FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40
Posts: 838
Joined: Wed Aug 22, 2007 10:09 AM

Re: ADO back up full database

Posted: Mon Sep 16, 2019 06:01 PM

Up!

Saludos / Regards,



FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40
Posts: 3358
Joined: Fri Oct 07, 2005 08:20 PM

Re: ADO back up full database

Posted: Mon Sep 16, 2019 06:32 PM

Moises:

Take a look at MySqlDump.exe and MySQL.Exe

Regards

SOI, s.a. de c.v.
estbucarm@gmail.com
http://www.soisa.mex.tl/
http://sqlcmd.blogspot.com/
Tel. (722) 174 44 45
Carpe diem quam minimum credula postero
Posts: 838
Joined: Wed Aug 22, 2007 10:09 AM

Re: ADO back up full database

Posted: Tue Sep 17, 2019 11:53 AM

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

Saludos / Regards,



FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40
Posts: 838
Joined: Wed Aug 22, 2007 10:09 AM

Re: ADO back up full database

Posted: Wed Sep 18, 2019 07:08 PM

Up!

Saludos / Regards,



FWH 20.04, Harbour 3.2.0 dev (r1909261630) y BCC 7.40

Continue the discussion