Title: encoded values in backup sql file
Last modified: June 2, 2017

---

# encoded values in backup sql file

 *  Resolved [triplebit](https://wordpress.org/support/users/triplebit/)
 * (@triplebit)
 * [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/)
 * In all of my sites the database backup file is different from the direct backup
   file that I get from phpmyadmin.
    Editing these files with text editor i see 
   that With backwpup some items are different as if they are encoded(like siteurl);
   Does anyone know why? Can I cause the backwpup sql file be the same? Thx

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

 *  Plugin Contributor [Brandon Olivares](https://wordpress.org/support/users/cocreation/)
 * (@cocreation)
 * [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/#post-9191858)
 * Hi [@triplebit](https://wordpress.org/support/users/triplebit/), this encoding
   is intentional to protect any values that might be binary encoded. It’ll import
   into your database perfectly fine. If you like, you can set up a test database,
   and try importing the SQL file to test whether it imports properly for you.
 *  Thread Starter [triplebit](https://wordpress.org/support/users/triplebit/)
 * (@triplebit)
 * [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/#post-9192210)
 * Thanks Mr. Olivares
    I want to be able to edit the sql file so I need somehow
   to restore it to its original values. Is it possible and how? Thx
 *  Thread Starter [triplebit](https://wordpress.org/support/users/triplebit/)
 * (@triplebit)
 * [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/#post-9192217)
 * By the way I think its a great plugin and it rescued me a few times…
 *  Thread Starter [triplebit](https://wordpress.org/support/users/triplebit/)
 * (@triplebit)
 * [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/#post-9192324)
 * I though on a some workaround, please refer if you can.
    Before editing I can
   import to any database and than export it with phpmyadmin. The exported file 
   should be decoded. Is that right? Thx
 *  Plugin Contributor [Brandon Olivares](https://wordpress.org/support/users/cocreation/)
 * (@cocreation)
 * [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/#post-9192334)
 * Yes that’s correct.
 * In the next release we’ll limit the columns that get encoded so it’s only binary-
   type columns.
 * I’m glad this could get resolved. 🙂
 * If you are happy with our free plugin and support, please make us happy and take
   30 seconds to [leave a review](https://wordpress.org/support/plugin/backwpup/reviews/).
   🙂 We’d really appreciate that.
 *  Thread Starter [triplebit](https://wordpress.org/support/users/triplebit/)
 * (@triplebit)
 * [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/#post-9193711)
 * Ok

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

The topic ‘encoded values in backup sql file’ is closed to new replies.

 * ![](https://ps.w.org/backwpup/assets/icon-256x256.png?rev=3236141)
 * [BackWPup – WordPress Backup & Restore Plugin](https://wordpress.org/plugins/backwpup/)
 * [Support Threads](https://wordpress.org/support/plugin/backwpup/)
 * [Active Topics](https://wordpress.org/support/plugin/backwpup/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/backwpup/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/backwpup/reviews/)

 * 6 replies
 * 2 participants
 * Last reply from: [triplebit](https://wordpress.org/support/users/triplebit/)
 * Last activity: [9 years ago](https://wordpress.org/support/topic/encoded-values-in-backup-sql-file/#post-9193711)
 * Status: resolved