MySQL Forums
Forum List  »  Backup

Re: Backup with greek characters and mysqlimport
Posted by: Yannis Roussos
Date: October 25, 2005 10:47AM

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).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Backup with greek characters and mysqlimport
2394
October 25, 2005 10:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.