Tuesday, September 26, 2023 at 3:48 PM
The easiest way to backup all mysql tables is to copy the /var/lib/mysql/ folder to your backup drive. Then, before mysql-server is installed (or stopped if installed), copy the /var/lib/mysql/ from your backup drive to your main drive. No need to export to SQL and then import. I still have all databases, users and tables.