0

I want to archive my tables that resides in MySQL database using InnoDB as storage engines. The tables are created using InnoDB.

Nikhil
  • 207
  • 1
  • 3
  • 15

1 Answers1

0

You can archive table by using mysqldump. It can be used to dump a database or a collection of databases for backup or transfer to another SQL server

mysqldump --defaults-extra-file=/home/username/.my.cnf database table > table.sql

For further reference see here.

Community
  • 1
  • 1
Avinash Babu
  • 6,171
  • 3
  • 21
  • 26
  • Does mysqldump compresses the data also. Also, is there any other way than mysqldump? – Nikhil Jul 29 '14 at 10:01
  • i dont know any other way would do this ..but mysqldump would ..accept the ans if that helps ..:) – Avinash Babu Jul 29 '14 at 10:07
  • Ok. I will accept it. Let me try first or think of some other scenario/ problem. I hope you don't mind. – Nikhil Jul 29 '14 at 10:31
  • Avinash, Can you please answer/help out in one of my questions? http://stackoverflow.com/questions/24939964/mysql-could-not-replicate-in-case-master-is-down-in-cluster-and-then-gets-up – Nikhil Jul 29 '14 at 10:58
  • can you accept this answer is this session is over ?? – Avinash Babu Jul 29 '14 at 13:26