Change InnoDB to MYISAM after restore
I create bad situations and learn backup and recovery. There are MYISAM and InnoDB Tables in my Databases.
The databases where backuped with:
mysqldump --single-transaction --flush-logs --master-data=2 --all-databases > backup_saturday_1_PM.sql
After it, I droped the tablespace ibdata1 in the datadir.
I restore all databases with:
./bin/mysql -u root -p </backup/frank/backup_suturday_1_PM.sql
All databases are okay, but all tables are in MYISAM-format now.
Can somebody tell me the reason?
Subject
Written By
Posted
Change InnoDB to MYISAM after restore
June 10, 2006 06:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.