Percona Server 5.7 needs slightly different answers passed to debconf-set-selections to allow unattended / silent installation:
If you have dumped all MySQL databases into one file (mysqldump --all-databases), you may have issues restoring a single database from that file. You can use awk to split the whole database dump into separate databases. * first save this script * and then run it against all_dbs.sql file:
With MySQL, for most use cases, InnoDB is a much better database engine than MyISAM. If you have plenty of databases with tables in MyISAM format which you'd like to convert to InnoDB, here is a bash script which will do it. The script only converts MyISAM tables, and will
If you want to use mysql command to connect to MySQL server running on localhost, but on nonstandard port (not 3306), you may notice that whatever port you specify, it will connect you to the default MySQL server running on port 3306: This is because if you specify "-h localhost"