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

error copying databases

forums › forums › SQLyog › Using SQLyog › error copying databases

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 22, 2004 at 2:40 am #8578
      arugam
      Member

      I am using the free version 3.1 SQLyog.

      I am running mysql server version 4.1.1a-alpha-nt on my local pc, when I connect to another web hosted database running Client API version 3.23.49 (from phpinfo) and attempt to copy tables I get an error because of the default charset (ENGINE=MyISAM DEFAULT CHARSET=latin1) line from the 4.1.1 server is incompatible with the 3.23.49 database.

      Is there any way around this problem, do later versions of SQLyog cater with this problem, I am considering upgrading to the new SQLyog primarily to allow synchronising of databases, but as I have no say as to how hosting companies configure mySQL or which version they choose to use I am wondering if synchronising would be a problem.

    • September 22, 2004 at 3:47 am #16304
      Ritesh
      Member

      In the COPY TABLE TO DIFFERENT HOST/DB… option, SQLyog just copies and executes the standard CREATE TABLE… SQL returned by MySQL. The CREATE TABLE stmt returned by MySQL ver 4.1.x returns information about CHARSET which is not compatible with MySQL 3.23.x. Therefore, in some cases you cannot copy table from a higher version of MySQL to an older version. We plan to resolve this issue in one of the future versions of SQLyog.

      Note: You will not face any problem related to above in DB Synchronization tool as SQLyog never executes CREATE TABLE stmt nor it requires CHARSET infromations. SJA is running successfully in many installations where one of the server is 4.1.x and the other 3.23.x.

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