Mysqldumper: Dumping each table separately

Question

How can I dump each mysql table separately with mysqldump?

Background: I want to track those dumps with git and using the pre-commit hook

Example: I have a schema with 10 tables (table1 - table10). now I want a file per table: table1.sql table2.sql ...

So how gonna this work?

Snd why stackoverflow don't like my question?

What do you mean with `Snd why stackoverflow don't like my question?` — Rene Pot, Feb 20 '12 at 09:48
http://stackoverflow.com/questions/3669121/dump-all-mysql-tables-into-separate-files-automagically/6300583 — kenorb, Oct 03 '13 at 17:00

score 33 · Answer 1 · edited May 07 '14 at 23:53

33

This should work in a shell:

for x in `mysql --skip-column-names -u [username] -p[password] [dbname] -e 'show tables;'`; do
     mysqldump -u [username] -p[password] [db name] $x > "$x.sql"
done

edited May 07 '14 at 23:53

Jonathan Leffler

698,132
130
858
1,229

answered Feb 20 '12 at 12:15

Edson Medina

9,077
3
41
49

1

Actually Naveen Kumar's answer is better than mine. – Edson Medina Feb 23 '12 at 11:14
5

No, your answer is better :) thanx – tasmaniski Oct 31 '13 at 14:08

score 1 · Answer 2 · answered Feb 20 '12 at 09:51

1

mysqldump -t -u [username] -p test mytable

will dump the table 'mytable' from the database 'test'.

If you want to automate the procedure, you will need to write a script, that selects the table_names from the schema for you and apply the operation above for each table. You can automate the git operations as well.

answered Feb 20 '12 at 09:51

hovanessyan

32,578
7
55
79

1

Depends on your operation system. If you're using Linux - bash scripting probably. – hovanessyan Feb 20 '12 at 11:18

Mysqldumper: Dumping each table separately

2 Answers2

Linked