BBS:      TELESC.NET.BR
Assunto:  Re: MySQL dumps (was Re: Citadel? Courier? Cyrus? Dovecot? - I just wan
De:       Lawrence D?Oliveiro
Data:     Tue, 13 Jan 2026 09:30:01 +1100
-----------------------------------------------------------
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)

-----------------------------------------------------------
[Voltar]