best practice for backup MySQL InnoDB tables?

Question

What is the best practice for backing up MySQL InnoDB tables? (for myisam I use backuppc)

How can I do a backup and how can I restore it?

Thank you.

The best practice is using console command mysqldump i think — Alex, Apr 15 '14 at 10:12
this site gives sols for worked code.so ask this in another portal — Ajay, Apr 15 '14 at 10:30

score 0 · Answer 1 · answered Apr 15 '14 at 10:18

0

mysql> mysqldump -u username -ppassword databasename tablename > Path to save

you can schedule in in windows scheduler or in cron job after creating the batch file or SH file.

answered Apr 15 '14 at 10:18

Tabish

score 0 · Answer 2 · answered Apr 15 '14 at 10:21

0

You can use 'mysqldump' program from MySQL to dump individual tables..

shell> mysqldump [options] [tbl_name ...]

To restore the tables use command:

shell>mysql -uusername -ppassword -f -D databasename < /path/to/file/dbbackup.sql

answered Apr 15 '14 at 10:21

skstar

shouldn't I use the **--single-transaction** option for making a consistent snapshot? – user3535392 Apr 15 '14 at 12:03
1

yes you should use it, useful for Innodb tables. I am using it. – skstar Apr 16 '14 at 03:20

2 Answers2