How to dump all databases in multiple files

written by Admin


Posted on 2014-10-06


Problem

I want to dump in a folder all my databases: a file for each db.

Solution

Run this script:
cd "C:\Program Files\MySQL5\MySQL Server 5.6\bin"

mysql.exe -uUSER -pPASS -s -N -e "SHOW DATABASES" | for /F "usebackq" %%D in (`findstr /V "information_schema performance_schema"`) do mysqldump %%D -uUSER -pPASS > C:\backup\dump\%%D.sql
Put in USER the username of a database user that can access (SELECT permission) each database and put in PASS the password (without spaces).

Don´t forget to customize file-names, folder-names and the path of mysqldump.

Feedback


Leave a Comment:


Search

Categories

android x 1
apache x 1
apple x 4
backup x 2
cygwin x 1
dns x 1
dos x 1
drupal x 3
ftp x 1
iis x 1
imap x 1
linux x 22
mail x 4
mysql x 3
oracle x 1
pop3 x 1
print x 2
proxy x 1
rsync x 1
shell x 8
smtp x 1
squid x 1
ssh x 1
storage x 2
web x 3
windows x 15

Welcome

We need collaboration and a real boost from our community: write us an email for every trick you find!

This website is a sysadmin swiss-knife for every-day Windows, Linux and Mac administration and troubleshooting

Our database grows if YOU send us your tips and trick as soon as you find them every day!