i keep searching for migrating existing database from MYISAM Engine to INNODB Engine. and i move my database to "Amazon RDS MySQL DB". I got few more links but i couldn't figure proper solution.
I have huge number of databases and tables.
So i need few answers.
- How to take back up all databases and tables ?. So i take backup either zip file or normal table back up ?.
- How to process import this back file in Amazon RDS MYSQL DB ?
- How to convert MYISAM to INNODB without data loss ?
References :
Importing Data to an Amazon RDS MySQL DB Instance with Reduced Downtime
Importing Data From Any Source to a MySQL DB Instance
Working with InnoDB Tablespaces to Improve Crash Recovery Times
Convert from MySQL MyISAM to InnoDB Storage Engine
Converting Tables from MyISAM to InnoDB
convert your existing MyISAM tables to InnoDB
Convert MyISAM to InnoDB database
Please let me know my reference files are correct or i need to learn more about Amazon RDS and Migrate MYISAM to INNODB.
Aucun commentaire:
Enregistrer un commentaire