Script bat for mysqldump

Discussion forum for all Windows batch related topics.

Moderator: DosItHelp

Post Reply
Message
Author
ame555
Posts: 1
Joined: 23 Dec 2020 13:10

Script bat for mysqldump

#1 Post by ame555 » 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.

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
Expert
Posts: 4043
Joined: 22 Jan 2010 18:01
Location: Germany

Re: Script bat for mysqldump

#2 Post by aGerman » 24 Dec 2020 08:39

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

Steffen

Post Reply