2 messages in com.mysql.lists.win32RE: mysqldump of UTF8 db
FromSent OnAttachments
Theodosios Paschalidis05 Mar 2004 09:19 
PF: MySQL05 Mar 2004 09:53 
Subject:RE: mysqldump of UTF8 db
From:PF: MySQL (ml.m@in-genius.com)
Date:03/05/2004 09:53:49 AM
List:com.mysql.lists.win32

I was just testing if my utf8 table would restore properly. When I execute mysqldump -umysqladmin -pmysqladmin test < C:\mysql\bin\test-bp.sql

Try:

To get good SQL file:

mysqldump.exe --quick --quote-names --all-databases --result-file=C:\backup.sql (the above is all one line)

To restore SQL file:

MYSQL.EXE -e "source C:\backup.sql" --force (the above is all one line)

-kevin