Re: restore of mysqldump-ed data is corrupted

2005-10-22 Thread Gleb Paharenko
Hello. > mysqldump options. I have backup data stored in sql file which Icannot > get back in same form as it was in database. I see now the problem. For a pity, the dump could be made with loss of the information. However this way might be helpful. Put SET NAMES 'UTF8'; line in the b

Re: restore of mysqldump-ed data is corrupted

2005-10-21 Thread Coba
Gleb Paharenko wrote: Are you able to get a correct data in some way (through PHP for example)? Or every method you have tried produces a wrong data? I know for one and only method: mysql -u root -p database < backup.sql. If you know for some other method, please share it with me. mysqldump

Re: restore of mysqldump-ed data is corrupted

2005-10-19 Thread Gleb Paharenko
Hello. > what do you really mean? I cannot have different symbols (hebrew,thai, > cyrillic) in same table!? I wouldn't say so. This project started when We have a lots of changes in MySQL 4.1. These are include the different character set support. In MySQL 4.1 during the work data might hav

Re: restore of mysqldump-ed data is corrupted

2005-10-19 Thread gioklio
Gleb Paharenko wrote: Hello. Are you sure that you have the same problem (the same character set settings, same broken cyrillic characters and so on)? If not, please, provide as much info as you can. Delyan was using cyrillic symbols with latin1 encoding, which is not designed for this purpos

Re: restore of mysqldump-ed data is corrupted

2005-10-18 Thread Gleb Paharenko
Hello. > This is the same problem that Delyan Toshev reported on > September 18 2005 4:27pm but that post is still unanswered: Are you sure that you have the same problem (the same character set settings, same broken cyrillic characters and so on)? If not, please, provide as much info as y