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

Can't Back Up From New Server To Old Server

forums › forums › SQLyog › Using SQLyog › Can't Back Up From New Server To Old Server

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 29, 2006 at 10:58 am #9922
      terrymechan
      Member

      I am running mysql 3.23.39 on my local server. MY ISP used to run similar but has now up graded to 4.1.2 and is thinking of moving to mysql v5.

      Since he has upgraded, My sqlyog locks up when trying to back up my tables or db from his server to my server. The tables in his new Mysql has a collation field, my does not.

      What are my options. Is the locking up caused by the different version of mysql.

      terry

    • September 29, 2006 at 12:50 pm #22642
      peterlaursen
      Participant

      One question only please! 🙂

      Quote:
      I am running mysql 3.23.39

      I think you should realy consider upgrading MySQL on your local server! 3.23.39 is a very old boy! You can actually read here http://www.mysql.com/company/legal/mysql_l…ycle_policy.pdf that MySQL AB is very close to completely drop support for 3.23!

      MySQL does not care much about compability between versions. Especially versions before 4.1 and after have issues with restore/backup. Charset management, TIMESTAMP implementation and more. SQLyog has no option for 'backwards compatible backup'. You will need to edit the .SQL file. Note however that the backup 'powertool' of ENTERPRISE version has an option to deselect UTF8-encoding.

      Quote:
      … has now up graded to 4.1.2

      I doubt this! 4.1.2 is an early alpha. You mean 4.1.21?

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