I'm using MySQL Server 5.5 and need to schedule a daily database backup.
Am currently doing the following in a batch file:

```
set currdate=%date:~4%
Set FileDate=%currdate:/=_%

mysqldump -u root-proot db > "C:\backup\database\db%FileDate%.sql"

```

It exports all tables in a single file. I want to export one file per table.