My existing MySQL database is running on 11.1. I plan to do a fresh install of 11.3 in order to utilize the trimming feature for SSD drives.
How should I install my MySQL database to the new version?
Do I perform a backup then restore to the new install? Or can I just save the mysql db files to a cd and somehow attach it to the new install?
I’m running MySQL 5.0
Best is to do a DB dump e.g. with mysqldump and then a restore.
Do bear in mind that the default language of mysql has changed to Unicode; how significant this will be will depend on what characters you have used in your earlier databases. But if you have used a wide range of characters check the commands to alter the language when dumping/restoring.
See this previous post http://forums.opensuse.org/english/get-help-here/applications/430500-mysql-charset-problem-after-upgrade-11-1-11-2-a.html and others which can be found by searching on ‘mysql utf8’