Script bat for mysqldump
Posted: 23 Dec 2020 13:21
i'm creating an import/export script with mysqldump i run the program but it doesn't create any files.
I appreciate your time.
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