Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Migration Of Mysql Database

forums › forums › SQLyog › Using SQLyog › Migration Of Mysql Database

Tagged: 

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 5, 2013 at 10:07 pm #12942
      petrescu
      Member

      Hi,

      I was wondering if SQLyog would be capable of migrating of a database running on MySQL version '4.0.20a-debug' [Windows 32bit] server to a CentOS 6/64bit based MySQL version 5.1.66 server?

      Thanks,

      fpt

    • March 6, 2013 at 4:08 am #34222
      peterlaursen
      Participant

      Should not be problem. SQLyog works with MySQL versions from 3.23.x. Operating systems don't matter at all.

      With SQLyog just open a connection to each server. From the connection to the 4.0 server right-click the database and select 'Copy database to other host/database'. Create the database to import to of 5.1 in advance. Note that 5.1 has a 'default character set' setting on the database level (4.0 only has on the server level). Choose the one that matches the encoding of you data (what will most likely be 'latin1' as 4.0 did not have utf8 or other unicode options)

      If you have more database on the server you repeat the step for each database. Or simply dump/export and import.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.