Dump Mysql tables from a database, 1 table per file, using a bat file. db tables to separate sql files via Windows Batch script.

gistfile1.txt

@echo off

set /p userDBName= Enter db name to backup:

set /p userHost= Enter mysql host (e.g. 127.0.0.1):

set /p userName= Enter mysql username (e.g. root):

:: This is set to my local time, in uk time format I would presume
md C:\backups\%userDBName%-%DATE:~-4%-%DATE:~-7,2%-%DATE:~0,2%

:: You'd probably need to edit this to get to your mysql.exe
cd C:\xampp\mysql\bin

echo Enter your mysql password
mysql -s -e "SHOW TABLES FROM "%userDBName% -h %userHost% -u %userName% -p --skip-column-names > C:\backups\tables.txt

echo Enter your mysql password again
for /f %%A in (C:\backups\tables.txt) DO (mysqldump -h %userHost% -u %userName% -p %userDBName% %%A > c:\backups\%userDBName%-%DATE:~-4%-%DATE:~-7,2%-%DATE:~0,2%\%%A.sql)

echo Export finished
pause >nul