Re: problem with mysqldump, ustf8 with mysql 4.1

"neal" <[EMAIL PROTECTED]> wrote: > 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.e

problem with mysqldump, ustf8 with mysql 4.1

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