I need to backup a mysql 4.1 database with UTF8 characters using InnoDB
and then restore the backup on another machine
 
I tried the following (same machine - Windows XP)
  mysqldump.exe -u root stp2 city > d1.sql                # backup
stp2.city
  mysql.exe -u root t1 < d1.sql                                  #
restore to t1.city
 
The UTF8 data in city.City is garbage after the transfer , it is valid
Thai language characters in the original.
 
CREATE TABLE `city` (
  `city_id` int(11) NOT NULL default '0',
  `City` varchar(25) NOT NULL default '',
  `EngCity` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`city_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
Any help would be appreciated,
 
Neal Katz
 
 

Reply via email to