SQL dump encoding | ww.wp.xz.cn

Resolved fancsali
(@fancsali)

2 years, 2 months ago

I was working on a site, and had a little hiccup with one of the data tables when doing some import/export with another plugin.

Long story short, I had to restore one of the tables from a mysqldump, and was trying to find the latest one – I also checked the files/backups created by UpdraftPlus and I found, that due the fact that we have binary columns in tables the reading the dump file in a proper UTF8 capable text editor things are really weird and broken.

Has anyone else experienced this problem? Does it cause any issues in practice?

Viewing 3 replies - 1 through 3 (of 3 total)

Plugin Support vupdraft
(@vupdraft)

2 years, 2 months ago

I think this is what you need: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html

https://dev.mysql.com/doc/refman/8.0/en/alter-database.html

Thread Starter fancsali
(@fancsali)

2 years, 2 months ago

Indeed, I can do it by hand with mysqldump – what I meant was, whether this is taken into account in the plugin?

I cannot safely alter the database columns for plugins that create their tables. To be honest, many times one does not really have any direct DB access at all…
Plugin Support vupdraft
(@vupdraft)

2 years, 2 months ago
When you restore with UpdraftPlus do you get a choice of character set to choose from (it would be in the form of a dropdown)?

Are you able to restore the table from UpdraftPlus on a local site/test site and send me the restoration log from the wp-content/updraft directory of your site?

Please post the log using a tool such as pastebin.com
- This reply was modified 2 years, 2 months ago by vupdraft.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘SQL dump encoding’ is closed to new replies.

3 replies
2 participants
Last reply from: vupdraft
Last activity: 2 years, 2 months ago
Status: resolved