Change InnoDB to MYISAM after restore
Posted by: Beate Schlesiona
Date: June 10, 2006 06:21AM

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?

Options: ReplyQuote


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.