CODEWITHSUNDEEP
backupinnodbmysql
Adil
Adil

Reputation: 21

MySQL backup only innodb tables

How, can I backup only the Innodb tables.

I'm looking for command line solution.

Thanks for your feedback.

Upvotes: 0

Views: 219

Answers (2)

Adil
Adil

Reputation: 21

mysqlbackup utility isn't available in Community installation !

I'll try msqldump.

First I list all the InnoDB tables, then I execute the msqldump on each of these tables (loop).

Upvotes: 0

Haim Evgi
Haim Evgi

Reputation: 125456

if you are using mysqlbackup , you can do it using --only-innodb option 

 mysqlbackup --defaults-file=/home/pekka/.my.cnf --only-innodb backup

look on http://dev.mysql.com/doc/mysql-enterprise-backup/3.7/en/only-innodb-usage.html

Upvotes: 2

Related Questions