MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
Encoding problem Options · View
LS
#1 Posted : Thursday, November 17, 2011 7:59:41 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
Hello,

I have database with character set "utf8" and collate "utf8_unicode_ci".
When I export it using MySqlBF values in insert statement where are Polish letters (ęółśążźćń) are corrupted.
How can I make it export correctly? When I use export in phpMyAdmin everything works OK...

I would be gratefull for any help.

LS
LS
#2 Posted : Thursday, November 17, 2011 8:01:28 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
I made a mistake in previous post. There should be collate "utf8_polish_ci".

LS
mikeshilov
#3 Posted : Thursday, November 17, 2011 8:04:04 AM
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
What connection type do you use for backup? TCP/IP or phpMyAdmin?
LS
#4 Posted : Thursday, November 17, 2011 8:07:05 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
I've checked that the same situation is with "utf8_unicode_ci" and "latin2_general_ci" collate.

LS
LS
#5 Posted : Thursday, November 17, 2011 8:08:26 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
mikeshilov wrote:
What connection type do you use for backup? TCP/IP or phpMyAdmin?


TCP/IP


LS
mikeshilov
#6 Posted : Thursday, November 17, 2011 9:12:52 AM
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Please try version 1.1.5, this issue should be fixed there.
LS
#7 Posted : Friday, November 18, 2011 1:58:27 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
mikeshilov wrote:
Please try version 1.1.5, this issue should be fixed there.

Version 1.1.5 fixed problem.
On your website on the home page you have different version of application (1.1.4) than in download section (1.1.5).

LS
Alexander Omelchenko
#8 Posted : Thursday, August 18, 2016 5:56:28 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Thanks, please feel free to contact us on any issues or concerns.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com