MySQL Forums
Forum List  »  Backup

Backup with greek characters and mysqlimport
Posted by: girionis chrysaorides
Date: July 29, 2005 07:32AM

Hello, I developed a dictionary application in Java and mysql as the back end database server. The application was originally running on a windows computer. I decided to migrate completely to Mandrake Linux 10.0 and I took a backup of the database using the "mysqldump" command. The whole database contained tables with greek (ISO-8859-7) characters.

I am now trying to import the data back to mysql by using the "mysqlimport" command but it seems that mysql does not recognize the greek characters. Although the number of records seem to be inserted correctly into the database (I get 227 records, that was the size of the data) the actual data (i.e. the words) have the value NULL. All of them. I have started the server using the --default-character-set=greek but to no avail. Note that if I open the backup file from the openoffice Writer word processor all data is displayed correctly.

Anyone has any ideas what could be going wrong? I would appreciate any help.

Kind regards

My specs are:

Mandrake Linux 10.0
AMD Athlon 1.4
MySQL 4.1 Linux (x86, glibc-2.2, static (Standard only), gcc)

Options: ReplyQuote

Written By
Backup with greek characters and mysqlimport
July 29, 2005 07:32AM

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.