Hot answers tagged


You can use replace into flag (--replace) and where condition (--where) while also omitting the create statement (-t): mysqldump -t --replace --where="id between 901 and 1000" my_db1 table my_table


Under MySQL 5.7, ROW_FORMAT=FIXED is no longer an option for the InnoDB Storage Engine. According to the MySQL 5.7 Documentation for innodb_default_row_format, these are values you can use for the table's row format: DYNAMIC, COMPACT, and REDUNDANT are allowed as default values COMPRESSED is not allowed to a default value, but you can explicitly use ...

Only top voted, non community-wiki answers of a minimum length are eligible