Tag:

MySQL

  • How to Make MySQL 8 Compatible With Older MySQL Versions
    Make MySQL 8 compatible with old MySQL versions. Make passwords compatible, and deal with errors. See some examples of setting SQL Modes in MySQL 8.
  • Conditional or Partial MySQL Dump
    Do mysqldump conditionally:
    • Export some tables only.
    • Ignore some tables.
    • Limit the number of rows.
    • Export procedures and functions only.
    • Export the database structure only.
    • Export InnoDB tables without locking them, etc.