database size : 100gb
storage engine : innodb
backup using mysqldump
restoration time : >5days
1.when iam restoring the database of 100gb it is taking more than 5days to
restore everything.could some one tell me how can i minimize this time?are
there any parameters I can tune to minimize this process?
2.when checking the table type after restoring it is showing the table type
as Myisam, but dump file has all the table are in innodb.Why the table type
has changed after restoration?
3.when restoring the schema from the schema.dump file iam getting an error
*ERROR 1166 (42000) at line 2786: Incorrect column name 'CAST( GROUP_CONCAT(
CONCAT(column_name) ORDER BY columns',')'*
Could someone please give your thoughts
|• backup and restoration||asmith varma||30 Sep|