Mysql 4.1 To Mysql 4.0 Charset Problems

This topic is empty.

Viewing 4 reply threads

Author

Posts
- August 14, 2005 at 3:38 pm #9167
  
  Tudsta
  Member
  
  When copying my tables from a 4.1 server to a 4.0 server, I get charset errors. To get around this problem, I have to Export as SQL Dump, edit the dump file removing all charset references, and importing to the 4.0 server. *sigh*
  
  Can SQLyog please be made to ignore the charset for databases that don't support charset?
- August 14, 2005 at 3:49 pm #18914
  
  peterlaursen
  Participant
  
  read here:
  
  http://www.webyog.com/forums/index.php?sho…st=0&#entry6846
  
  Simply delete the charset's definition from the SQL-file using Notepad or another editor.
  
  Quote:
  
  Can SQLyog please be made to ignore the charset for databases that don't support charset?
  
  it is not a SQLyog issue – it is a MySQL issue!
- August 15, 2005 at 1:06 pm #18915
  
  peterlaursen
  Participant
  
  and BTW …
  
  the “workaround is there”. You can use the ODBC-tool!
- August 15, 2005 at 2:21 pm #18916
  
  Ritesh
  Member
  
  peterlaursen wrote on Aug 14 2005, 03:49 PM:
  
  Simply delete the charset's definition from the SQL-file using Notepad or another editor.
  
  it is not a SQLyog issue – it is a MySQL issue!
  
  [post=”6851″]<{POST_SNAPBACK}>[/post]
  
  SQLyog uses MySQL's SHOW CREATE table statement in the generated dump file. The other option would be to read thru each and every columns definition and create the CREATE TABLE statement.
  
  We prefer to use MySQL's SHOW CREATE table option because it is easier to keep up with the changes that MySQL does from version to version.
- June 5, 2008 at 6:11 pm #18917
  
  UL MMM
  Member
  
  i cant access this page!
Author

Posts