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 / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]