Results 1 to 3 of 3

Thread: Upgrading to 11.3...need mysql help

  1. #1

    Default Upgrading to 11.3...need mysql help

    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

  2. #2
    Join Date
    Jun 2008
    Location
    UTC+10
    Posts
    9,686
    Blog Entries
    4

    Default Re: Upgrading to 11.3...need mysql help

    Best is to do a DB dump e.g. with mysqldump and then a restore.

  3. #3
    Join Date
    Jun 2008
    Location
    West Yorkshire, UK
    Posts
    3,450

    Default Re: Upgrading to 11.3...need mysql help

    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/g...-1-11-2-a.html and others which can be found by searching on 'mysql utf8'
    Last edited by john_hudson; 17-Aug-2010 at 01:22. Reason: Additional information

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •