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

Forums | Webyog

Tools to manage and monitor MySQL databases

copy database error

This topic is empty.

Viewing 4 reply threads

Author

Posts
- December 6, 2004 at 2:32 pm #8686
  
  reinaldo
  Member
  
  SQLYog can´t copy databases from 4.1.7 to a 4.0.17 mysql server. The error is:
  
  Error Code : 1064
  
  You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 11
  
  (582 ms taken)
  
  Is there some way to work around this error?
  
  Thanks in advance
- December 6, 2004 at 2:41 pm #16647
  
  Ritesh
  Member
  
  SQLyog uses the query returned from “CREATE TABLE…” SQL to create tables between two hosts. It looks like the SQL returned from 4.0.17 is not compatible with 4.1.7.
  
  I have forwarded the issue to my development team.
- December 6, 2004 at 2:52 pm #16648
  
  reinaldo
  Member
  
  Ritesh wrote on Dec 6 2004, 02:41 PM:
  
  SQLyog uses the query returned from “CREATE TABLE…” SQL to create tables between two hosts. It looks like the SQL returned from 4.0.17 is not compatible with 4.1.7.
  
  I have forwarded the issue to my development team.
  
  Ok, but I using from 4.1.7 to 4.0.17. Not from 4.0.17 to 4.1.7.
- December 6, 2004 at 3:57 pm #16649
  
  Ritesh
  Member
  
  Oops. My mistake. I actually meant 4.1.7 to 4.0.17.
  
  The SQL returned from 4.1.7 is not backward compatible. Therefore, they dont work with 4.0.17.
- December 7, 2004 at 11:06 am #16650
  
  Shadow
  Member
  
  Replace the ENGINE keyword with TYPE and the CREATE TABLE statement will work as expected, unless you have some timestamp columns.
  
  Ritesh: SQLyog could detect the versions and do this conversion automatically!
Author

Posts

Viewing 4 reply threads

You must be logged in to reply to this topic.