I tried searching forum but could not get any relevant results. so here is the question.
How do I make a backup of my mysql database from node-red ?
I am able to create a backup using mysqldump command in the respective folder in windows command line opened as administrator. mysqldump -u user -ppassword dbase > backup1.sql
How do i use this in node-red using mysql node ?
quotes didnt help
i believe i have to change directory first and then execute the mysqldump since even in cmd prompt i am unable to execute the mysqldump directly from root
I couldn't get it going through NR.
Eventually wrote a batch file and made windows scheduler run the file every day. serves my prupose so not pursuing the NR way.