ADO back up full database

ADO back up full database

Postby MOISES » Fri Sep 13, 2019 2: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
MOISES
 
Posts: 838
Joined: Wed Aug 22, 2007 10:09 am

Re: ADO back up full database

Postby nageswaragunupudi » Fri Sep 13, 2019 4: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
User avatar
nageswaragunupudi
 
Posts: 10620
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: ADO back up full database

Postby MOISES » Fri Sep 13, 2019 5: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
MOISES
 
Posts: 838
Joined: Wed Aug 22, 2007 10:09 am

Re: ADO back up full database

Postby MOISES » Mon Sep 16, 2019 6:01 pm

Up!
Saludos / Regards,

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

Re: ADO back up full database

Postby Armando » Mon Sep 16, 2019 6: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
User avatar
Armando
 
Posts: 3201
Joined: Fri Oct 07, 2005 8:20 pm
Location: Toluca, México

Re: ADO back up full database

Postby MOISES » 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
MOISES
 
Posts: 838
Joined: Wed Aug 22, 2007 10:09 am

Re: ADO back up full database

Postby MOISES » Wed Sep 18, 2019 7:08 pm

Up!
Saludos / Regards,

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


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: russimicro and 48 guests