Migrate MyISAM tables to INNODB using mysqldump

Follow

Comments

4 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
  • Avatar
    Sofiya Williams

    I like your writing style. This article is helpful for my team. As a team leader, I personally thank you through this comment.MyISAM tables to INNODB

    0
    Comment actions Permalink
  • Avatar
    Neam

    Is it possible for the games data? I want to do that for carx street.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Powered by Zendesk