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)
Web-based telnet client
IRC
Email & news access