1. Forum
  2. FidoNet
  3. rberrypi

  • Re: MySQL dumps (was Re: Citadel? Courier? Cyrus? Dovecot? - I just wan

    From Lawrence D?Oliveiro@3:633/10 to All on Tuesday, January 13, 2026 09:30:01
    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)