Script bat for mysqldump

[ame555]

i'm creating an import/export script with mysqldump i run the program but it doesn't create any files.
I appreciate your time.

Code: Select all

@ECHO OFF
SET BACKUPS_DIR=c:\Users\User Name\Desktop
SET MYSQL_DIR=c:\Program Files\MariaDB 10.4\bin
SET USER="root"
SET PORT="3306"
SET PASSWORD="12345678"    

mysqldump -u %USER% -p %PASSWORD% --insert-ignore --no-create-info prueba fechas --where="fecha > curdate() - INTERVAL 2 DAY">%BACKUPS_DIR%\dbdatos.sql

[aGerman]

What shall we do with your topic? Is there any question, or are you facing any problem?

Steffen