1. Forum
  2. Usenet
  3. LINUX.DEBIAN.USER

  • Backup mysql

    From Bitfox@21:1/5 to All on Tue Dec 3 00:00:01 2024
    I run mysql on debian.

    I want to backup the tables for database grants and authentication. What
    tables should I pick to backup then?

    Thank you.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Andy Smith@21:1/5 to Bitfox on Tue Dec 3 00:20:02 2024
    Hi,

    On Tue, Dec 03, 2024 at 06:51:34AM +0800, Bitfox wrote:
    I run mysql on debian.

    Do you? Or do you run MariaDB?

    Debian supplies MariaDB but it is possible to get MySQL from elsewhere.

    I want to backup the tables for database grants and authentication. What tables should I pick to backup then?

    Just backup all of the `mysql` database. I'm sure it is possible to
    pare this down to only the tables you need but come on, this is a
    relatively small amount of text, what is the point in trying to micro
    optimise?

    Thanks,
    Andy

    --
    https://bitfolk.com/ -- No-nonsense VPS hosting

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)