backup innodb

From WebHostingNeeds.com
Jump to: navigation, search

Backup InnoDB database.

mysqldump --single-transaction DB_NAME > DB_NAME.sql

If Database Backup fail, use --force option.

mysqldump --single-transaction --force DB_NAME > DB_NAME.sql


Restore

mysql DB_NAME < DB_NAME.sql



innodb