Take the 2-minute tour ×
mysqldump -hlocalhost -uUSERNAME -pPASSWORD THEDATABASE | gzip > /home/db_backup/abc.sql.gz

tar -xzvf ./abc.sql.gz

mysql THEDATABASE -uroot -pPASSWORD < abc.sql

The important note is that currently, half of my tables are INNODB...and the other half are MYISAM.

If I run these commands...will my newly restored database keep the INNODB/MYISAM?

share|improve this question

2 Answers 2

up vote 2 down vote accepted

Look at the .sql file. Following each CREATE TABLE stanza, there should be an Engine= declaration. Those should match whatever engine the tables had when you performed the mysqldump. As long as the target mysql instance supports both storage engines, you should be all set.

share|improve this answer
I can't "look" at the file because I have 100 million rows in the database :/ –  Alex Dec 8 '09 at 20:37
You should be fine. I've never seen a mysqldump not include the Engine definition. –  EEAA Dec 8 '09 at 21:04

Beware of auto-increment integer fields that have a 0 value record -- I got bit by that: http://wiki.xdroop.com/space/MySQL/mysql+backup+and+restore+problem

share|improve this answer

Your Answer


