diff options
| author | unknown <stewart@willster.(none)> | 2006-10-05 00:56:06 +1000 |
|---|---|---|
| committer | unknown <stewart@willster.(none)> | 2006-10-05 00:56:06 +1000 |
| commit | 121d7b39f153206034a48b98e140300fa3769df5 (patch) | |
| tree | d20ce88fcbf511c8d71417c2c9b7d1fb55ad61fc /client/mysqldump.c | |
| parent | e963a7cd3458618d27c59f242c6939fe7b66c61f (diff) | |
| download | mariadb-git-121d7b39f153206034a48b98e140300fa3769df5.tar.gz | |
BUG#20809 mysqldump does not backup TS and LG information correctly
restore of the dump (ndb_dd_dump test) was failing for probably a merge problem. fixed now.
client/mysqldump.c:
fix query to make dump restorable
Diffstat (limited to 'client/mysqldump.c')
| -rw-r--r-- | client/mysqldump.c | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/client/mysqldump.c b/client/mysqldump.c index bfafa92008e..f1e1d549f6a 100644 --- a/client/mysqldump.c +++ b/client/mysqldump.c @@ -2758,7 +2758,7 @@ static int dump_all_tablespaces() char *endsemi; if (mysql_query_with_error_report(mysql, &tableres, - "SELECT DISTINCT" + "SELECT" " LOGFILE_GROUP_NAME," " FILE_NAME," " TOTAL_EXTENTS," @@ -2768,6 +2768,8 @@ static int dump_all_tablespaces() " FROM INFORMATION_SCHEMA.FILES" " WHERE FILE_TYPE = \"UNDO LOG\"" " AND FILE_NAME IS NOT NULL" + " GROUP BY LOGFILE_GROUP_NAME, FILE_NAME" + ", ENGINE" " ORDER BY LOGFILE_GROUP_NAME")) return 1; |