Migrate MyISAM tables to INNODB using mysqldump

Follow

Comments

2 comments

  • 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)

    0
    Comment actions Permalink
  • Avatar
    bastiat666

    Explain sed-i.bak.
    Is that a typo?

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk