Title: SQL dump encoding
Last modified: March 19, 2024

---

# SQL dump encoding

 *  Resolved [fancsali](https://wordpress.org/support/users/fancsali/)
 * (@fancsali)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/sql-dump-encoding/)
 * 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](https://wordpress.org/support/users/vupdraft/)
 * (@vupdraft)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/sql-dump-encoding/#post-17516133)
 * 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/mysqldump.html)
 * [https://dev.mysql.com/doc/refman/8.0/en/alter-database.html](https://dev.mysql.com/doc/refman/8.0/en/alter-database.html)
 *  Thread Starter [fancsali](https://wordpress.org/support/users/fancsali/)
 * (@fancsali)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/sql-dump-encoding/#post-17516493)
 * 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](https://wordpress.org/support/users/vupdraft/)
 * (@vupdraft)
 * [2 years, 2 months ago](https://wordpress.org/support/topic/sql-dump-encoding/#post-17519140)
 * 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](https://wordpress.org/support/users/vupdraft/).

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

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

 * ![](https://ps.w.org/updraftplus/assets/icon-256x256.jpg?rev=1686200)
 * [UpdraftPlus: WP Backup & Migration Plugin](https://wordpress.org/plugins/updraftplus/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/updraftplus/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/updraftplus/)
 * [Active Topics](https://wordpress.org/support/plugin/updraftplus/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/updraftplus/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/updraftplus/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [vupdraft](https://wordpress.org/support/users/vupdraft/)
 * Last activity: [2 years, 2 months ago](https://wordpress.org/support/topic/sql-dump-encoding/#post-17519140)
 * Status: resolved