This will cover the installation and configuration of MySQL
The installation will ask for the root password for the database
sudo apt-get -y install mysql-server
Update the my.cnf file
Update the database location and the IP address to bind to
sudo vi /etc/mysql/my.cnf ... datadir = /mnt/apps/mysql-data ... bind-address = 0.0.0.0 ...
This is probably taken care when you upgrade a package, but it may need to be manually done.
sudo mysql_upgrade -h localhost -u root -p
For my upgrade I then had to repair some tables
mysql -u root -p mysql REPAIR TABLE `help_category`; REPAIR TABLE `help_keyword`; REPAIR TABLE `help_topic`; REPAIR TABLE `proc`; REPAIR TABLE `time_zone_name`;
sudo /etc/init.d/mysql restart
Importing tables in Windows
mysql -u username -ppassword database_name < data.sql