Other administration notes not included in other categories.
Fragmented mysql databases are known to slow down the mysql server. And these bases need to be sometimes optimized: to defragment.
There are two ways to optimize tables with the mysqlcheck utility. The first:
mysqlcheck -Ao
Here: key A checks tables for errors, and key o performs optimization.
The second way:
mysqloptimize -A
The value of the keys here is the same. :)
Importing and exporting a mysql database using the console, I think, is the most versatile and most convenient way, compared to the same phpmyadmin, which you need to install and configure. And work with the console takes a minimum of time.
Of course, you must have access to SSH, either directly to the console, if this is your local computer, or to VNC.