MySQL backup: database-sql.sql bad encoding | Report Bugs | Free Forums

All Wordpress Forum requests have been moved to Wordpress Support Forums

 

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
MySQL backup: database-sql.sql bad encoding
June 30, 2013
8:45 am
Avatar
Jiri
Member
Forum Posts: 3
Member Since:
June 30, 2013
sp_UserOfflineSmall Offline

Hi,

 

I have problem on my WordPress websites. I tried both versions of xCloner - special WP and standalone - and the same error.

 

all MySQL database data (table characters/collation ... and general characters/collation) are UTF-8

database-sql.sql encoding is cp1250

so... the text is broken (especially Czech words with special characters) (manually change database-sql.sql encoding to UTF-8 in backup filles didn't help, of course)

 

On other websites, I have my own administration system and everything is OK (database-sql.sql is correctly UTF-8 like all MySQL data).

 

How to fix this problem?

 

Thanks.

June 30, 2013
12:43 pm
Avatar
XCloner! Support
Admin
Forum Posts: 2485
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Is the Backup Mode option set to AJAX in your current install(XCloner Config->System tab)? In that mode, XCloner sets as default the utf-8 encoding! Ovidiu

Please consider our XCloner Premium Support or making a Donation XCloner.com – Backup Made Easy!
June 30, 2013
12:56 pm
Avatar
Jiri
Member
Forum Posts: 3
Member Since:
June 30, 2013
sp_UserOfflineSmall Offline

XCloner! Support said:

Is the Backup Mode option set to AJAX in your current install(XCloner Config->System tab)? In that mode, XCloner sets as default the utf-8 encoding! Ovidiu


Yes, it is set to AJAX.

 

All the files are correctly UTF-8, instead of database-sql.sql which is CP 1250 (I don't understand why because I had never use this encoding on this site.)

 

I see "básnÄ›" instead of "básničky", for example.

June 30, 2013
1:02 pm
Avatar
XCloner! Support
Admin
Forum Posts: 2485
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

If you have mysqldump and php exec() functin active, try and activate that option and see how it goes, the Backup Mode should be set to Normal for this to work! Ovidiu

Please consider our XCloner Premium Support or making a Donation XCloner.com – Backup Made Easy!
June 30, 2013
1:07 pm
Avatar
Jiri
Member
Forum Posts: 3
Member Since:
June 30, 2013
sp_UserOfflineSmall Offline

XCloner! Support said:

If you have mysqldump and php exec() functin active, try and activate that option and see how it goes, the Backup Mode should be set to Normal for this to work! Ovidiu


unfortunately, I have exec() function support:     DISABLED
Forum Timezone: UTC 0

Most Users Ever Online: 867

Currently Online:
5 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

tom_1: 70

mlguru: 33

Django29: 29

D: 21

Andy: 21

Marcus: 20

Member Stats:

Guest Posters: 737

Members: 41549

Moderators: 1

Admins: 1

Forum Stats:

Groups: 3

Forums: 7

Topics: 2517

Posts: 8419

Newest Members:

Broncopea Broncopea

Moderators: Ovidiu - Support!: 0

Administrators: XCloner! Support: 2485

Quick contact

place

Hi there, my name is Ovidiu Liuta and i support the XCloner! project
XCloner is a Joomla backup component, Wordpress backup plugin and Free website backup tool.
Contact me here!

About company

XCloner.com is a dynamic company focusing on providing backup and recovery solutions for small to medium websites.
We are based in Romania and offer 24/7 support through forums and our private ticket system for Premium users support.

© 2020 XCloner - Website Backup and Restore made simple
All Rights Reserved | Privacy Policy