Database backup

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.

Name
Password

No need to register, just enter the same name and password every time.