MSGID: <10k262s$25l4l$1@dont-email.me> afd4cc86
REPLY: <10k25dr$25dfj$2@dont-email.me> c6d2c0d6
PID: PyGate 1.5.2
TID: PyGate/Linux 1.5.2
CHRS: CP1252 2
TZUTC: 1100
REPLYADDR ldo@nz.invalid
REPLYTO 3:633/10 UUCP
Subject: Re: MySQL dumps (was Re: Citadel? Courier? Cyrus? Dovecot? - I just
want to backup my emails)

On Mon, 12 Jan 2026 06:47:23 -0000 (UTC), Markus Robert Kessler wrote:

> I am asking this because I once got into big trouble when I had to
> move multiple mysql databases to a new machine with new OS and new
> version of mysqld. - Nothing worked and I had to use mysql-dump to
> export the data as text-dump on the old system and import them into
> the new one. After that, the permission system also had to be set up
> from scratch because of different data format...

Using the dump format is how you?re supposed to do it. Been there,
done that, had to download and run an old MySQL binary to go back and
do the dump the proper way (thankfully old binaries are available for
just such a purpose).

mysqldump lets you include table permissions with the ?--system=users?
option.

--- PyGate Linux v1.5.2
 * Origin: Dragon's Lair, PyGate NNTP<>Fido Gate (3:633/10)
SEEN-BY: 105/81 106/201 128/187 129/14 305 153/7715 154/110 218/700
SEEN-BY: 226/30 227/114 229/110 112 134 200 206 275 300 317 400 426
SEEN-BY: 229/428 470 616 664 700 705 266/512 291/111 292/854 320/219
SEEN-BY: 322/757 342/200 396/45 460/58 633/10 280 414 418 420 422
SEEN-BY: 633/509 2744 712/848 770/1 902/26 2320/105 5020/400 5075/35
PATH: 633/10 280 229/426