备份mysql个人数据库

Question

I have a so many of databases all running from my local WAMPserver and have found that the command below runs well but has a problem with the databases that have spaced in their names, all other databases export with no problems its just the ones with spaces that display the error

the code I am using is below:-

mysql.exe -uroot -p1234 -s -N -e "SHOW DATABASES" | for /F "usebackq" %%D in (`findstr /V "information_schema performance_schema"`) do mysqldump %%D -uroot -p1234 > S:\Backup\MySQL\%%D.sql

The error I keep getting is on my database called "example data":-

mysqldump: Got error: 1049: Unknown database 'example' when selecting the data base

Any help is greatly appreciated.

Thanks