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