What's new in MySQL Data Dumper 0.9.1
Jan 4, 2016
- mydumper new features:
- Full schema support
- Views and merge tables are now handled also added:
- -d, --no-data Do not dump table data
- -G, --triggers Dump triggers
- -E, --events Dump events
- -R, --routines Dump stored procedures and functions
- --trx-consistency-only Transactional consistency only
- myloader new features:
- -s, --source-db Database to restore
- Bug Fixes:
- #1431410 innodb stats tables
- #1440403 *-post and *-triggers compressed files corrupt
- #1470891 functions may be needed by SP and views
- #1390437 segmentation fault against Percona MySQL 5.6.15-63.0
- #1446280 Segmentation fault on Debian Wheezy
- #1399715 Typo in –tables-list option in manpage
- #1428608 missing -K option in mydumper manpage
- #1440437 myloader: wrong database name in message when -B used
- #1457091 tokudb detection doesn’t work
- #1481747 Unable to compile r179 WITH_BINLOG=ON (undeclared ‘bj’)
- #1507574 Assertion when broken mrg tables
- #841651 dump view definitions
- #1485688 make compile error myloader.c:209
New in MySQL Data Dumper 0.6.2 (Sep 17, 2014)
- Bugs Fixed:
- 1347392 last row of table not dumped if it brings statement over statement_size
- 1157113 Compilation of latest branch fails on CentOS 6.3 64bit
- 1326368 Can't make against Percona-Server-devel-55 headers
- 1282862 unknown type name 'HASH'
- 1336860 k is used twice
- 913307 Can't compile - missing libs crypto and ssl
- 1364393 rows chunks doesn't increase non innodb jobs
- New Features:
- --lock-all-tables (instead of FTWRL)
- TokuDB support
- Support to dump tables from different schemas
New in MySQL Data Dumper 0.6.1 (Mar 11, 2014)
- New Features:
- Metadata Locking
- Added new option –use-savepoints to reduce metadata locking issues while backup is running.
- Bug fixes:
- #1273441 less-locking breaks consistent snapshot
- #1267501 mydumper erroneously always attempts a dummy read
- #1272310 main_connection keep an useless transaction opened and permit infinite metadata table lock
- #1269376 mydumper 0.6.0 fails to compile “cast from pointer to integer of different size”
- #1265155 create_main_connection use detected_server before setting it
- #1267483 Build with MariaDB 10.x
- #1272443 The dumping threads will hold metadata locks progressively while are dumping data.
New in MySQL Data Dumper 0.6.0 (Dec 23, 2013)
- NEW FEATURES:
- Consistent backups with less locking:
- This new feature consist on locking all non-innodb tables with the dumping threads at the begining so in this way we can unlock the flush tables with read lock earlier and no need to wait until all that tables were dumped. You can take advantage of this feature when you have big archive or myisam tables.
- File size chunks:
- Now you can split tables dump into different files with fixed size. This is usefull to reduce storage capacity needed to keep history backups by using hardlinks. Think on big "log" tables or tables where old data didnt change, now you will be able to hardlink back those chunks.
- FIXED BUGS:
- #1250269 ensure satetement is not bigger than statement_size
- #827328 myloader to set UNIQUE_CHECKS = 0 when importing
- #993714 Reducing the time spent with a global read lock
- #1250271 make it more obvious when mydumper is not successful
- #1250274 table doesnt exist should not be an error
- #987344 Primary key name not quoted in showed_nulls test
- #1075611 error when restoring tables with dashes in name
- #1124106 Mydumper/myloader does not care for 0-s in AUTO_INCREMENT fields
- #1125997 Timestamp data not portable between servers on differnt timezones
New in MySQL Data Dumper 0.5.2 (Jul 9, 2013)
- Fix sphinx version checking to avoid builds with outdated toolchain
- Extend instructions in README
- Fix CMakeMySQL to use multithreaded libs, as well as find library paths properly
- Suppress error condition on deprecated glib functions
New in MySQL Data Dumper 0.5.1 (Jul 9, 2013)
- Fix MySQL 5.0 compile issue
- Make the metadata file visible (after muliple requests)
- Add --no-lock option to mydumper
- First --daemon snapshot is now at execution instead of the first timed interval
- Fix CentOS 5.x compile issue (also affected Mac OSX)
- Fix libmysqlclient search bug
- Add cppcheck target
- Fix errors flaged by cppcheck
- Add option to turn off docs build
- Add status output at end of CMake
New in MySQL Data Dumper 0.5.0 (Jul 9, 2013)
- Added --daemon
- Added --snapshot-interval (--daemon snapshot time in minutes)
- Added --logfile (to log to file instead of console)
- Added signal handler
- Large changes to binlog handling
- Documentation updates