Re: Backup with greek characters and mysqlimport

[Yannis Roussos]

You can just mysqldump and then import using source:

mysqldump -F -l -u root -p --result-file=$YOURBACKUPDIR/$YOURBACKUPFILE -c --opt $YOURDB

mysql -u root $YOUR_RESTORE_DB -p

> source $YOURBACKUPFILE;

I have used it (in a windows enviroment) to take backups of a database containing tables with greek (ISO-8859-7) characters and it worked fine (MySQL 4.0.22 Windows).