devtuxtla wrote:Thanks...
Any idea for a quick implementation?
Regards
Hi Nages.
Ok via e-mail
Regards.
#include "fivewin.ch"
function Main()
local oCn
oCn := mysql_Connect( "localhost", "fwh", "gnrao", "secret" ) // DB selected is FWH
oCn:BackUp( NIL, "c:\mysqlbackups\" )
return nilFantastic Mr Nages 
Hello Ms. Nages
I use MariaDB/MySql Backup with great satisfaction .
Now I have two SQL Server databases. One is client and the second is on the server .
I use MariaDB/MySql Backup for the backup on the server , and MariaDB/MySql Restore on the client.
I saw that with mysqldump you can do it in one operation :
mysqldump --host=127.0.0.1 --port=3306 -uxxx -px mastronipe arti | mysql --host=192.168.0.254 --port=3306 -uxxxx -pxxxx mastropalmare
can you do the same with MariaDB/MySql Backup ? or there is a better way to replicate 2 databases ?
Regards Maurizio
Hi I have a question..
Is there any way to insert new records and that the table or tables are not deleted when executing a restore?
Thanks
No.
Hi,
I can´t get to work with ADO for MSSQL.
Thank you.
MOISES wrote:Hi,
I can´t get to work with ADO for MSSQL.
Thank you.
As sources are not available, can you please adapt these functions for ADO too?
At least, the backup function.
Thank you.
You can use the same backup/restore for any mysql/mariadb database whether your main application uses ADO or FWMariaLibs or any other libs like Dolphin,etc.
But this logic is not at all useful to any other database like MSSQL., Oracle, etc.
Hi,
What I mean is produce an output such as:
DROP TABLE IF EXISTS clientes;
CREATE TABLE clientes (
id_cliente int(11) NOT NULL AUTO_INCREMENT,
name varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id_cliente)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
INSERT INTO clientes VALUES (1,'Distribuidora Pepe'),(2,'Estacion de Servicio YPF'),(3,'Agropecuaria Venado');
-- {{"moises",0,645,FW_SToT("20200608100940337"),0.19000000,"TABLE"},{"clientes",645,391,FW_SToT("20200608100940567"),0.19100000,"TABLE"}}008B
This code can be executed in mostly RDBMS.
At least, the INSERT INTO for all values.
* New functions for MSSQL in adofuncs.prg
FW_MSSQL_Backup( oCn, cDb, cFile ) --> lSuccess
FW_MSSQL_Restore( oCn, cDb, cFile ) --> lSuccess
Thank you very much!
Will support Access too?
Access?
Simply copy mdb/accdb file to a safe place.
