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 beginning of the dump file and perform an import
as you usually do.
Coba wrote:
> 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 outputs the data in UTF8 by default, you can change the output
>> encoding using --default-character-set option.
>
> I know for that, but it's a little bit too late for playing with
> mysqldump options. I have backup data stored in sql file which I cannot
> get back in same form as it was in database.
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
