Migrate MyISAM tables to INNODB using mysqldump



1 comment

  • Avatar
    David Bennett

    The -R and --triggers options are not needed on the second mysqldump (data) as the functions, stored procedures, and triggers will be migrated in the first (schema) dump.   Recent changes in MySQL may make this even more problematic if your schema phase requires updates to the stored procedures and functions (such as ERROR 1418 validations)

    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk