[MDEV-32491] Mariadb-dump creates sql with NULLs in insert lines for CHAR columns Created: 2023-10-17 Updated: 2023-11-06 Resolved: 2023-11-06 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Backup |
| Affects Version/s: | 11.1.2 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Tadas Balaišis | Assignee: | Sergei Golubchik |
| Resolution: | Cannot Reproduce | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Server OS: Win64 |
||
| Attachments: |
export heidi.sql
maria-dmp2.sql
mariadb-dump-help.txt
mariadb-dump-mlf.sql
|
| Description |
|
Mariadb-dump executed as root creates sql with corrupt content. Insert lines contain NULL instead of original values for CHAR columns. |
| Comments |
| Comment by Sergei Golubchik [ 2023-11-03 ] | ||
|
this isn't a complete output of mariadb-dump. please show the complete output (of only one table, preferably, to have a smaller dump) and all mariadb-settings (the output of mariadb-dump --help) | ||
| Comment by Tadas Balaišis [ 2023-11-06 ] | ||
|
| ||
| Comment by Tadas Balaišis [ 2023-11-06 ] | ||
|
Oh, sorry. I got my mistake. I used the binary from old (10.5) bin. Now I tried with correct (11.1) home bin and it went well. The dump was OK, varchar values were included correctly. Thanks. | ||
| Comment by Sergei Golubchik [ 2023-11-06 ] | ||
|
I've tried to load your export heidi.sql | ||
| Comment by Tadas Balaišis [ 2023-11-06 ] | ||
|
DB is 11.1. And I tried to dump it with 10.5 mariadb-dump binary. | ||
| Comment by Sergei Golubchik [ 2023-11-06 ] | ||
|
ok, as you like. We'd still prefer if old mariadb-dump would be able to work with newer servers. But in my attempts to repeat this issue mariadb-dump worked, I failed to reproduce the problem. Thus, I'll close it as "Cannot Reproduce" Thanks! |
