From: ldo@nz.invalid   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)